I have searched but I might not be entering the right keywords.

I have a table1 on SHeet1 with a list of EmpID and EmpName. On a seperate sheet, table2, I have a drop down list compiled from the EmpID. Next to the drop down I have a blank cell. I want the blank cell to return the EmpName that matchs the EmpID. What function would I use. I assumed LOOKUP but it does not seem to work. I was trying

=LOOKUP(Sheet1[EmpID]=Table2[EmpID],Table1[EmpName])

Check out VLookup in help.

LOOKUP is a legacy function that has only been kept for reasons of compatibility. Like pbaldy said, you want to use a VLOOKUP.