Comparing two lists

[c5883]

I have the following data
NAME CODE

and
I have another list
NAME work

I'm trying to compare the two and give the results of CODE based o
name
here is an example
---------- WORK --------
James Home
Jame Work
Bob Outside
----- ASSIGNMENT ---------
James D
Bob C
------


So I want to have a forumla that looks for one of the lines comparis i
to a list and if it is true it will result in the cell next to it.

i've tried this which doesn't seem to work
=IF(WORK!A1=(OR(ASSIGNMENT!A:A),ASSIGNMENT!B1,"Cannot find")

SO
IF the cell in WORK has any of the NAMES in assignment then display th
code from the assignment chart

another example which would not be the way to go
=IF(WORK!A1=ASSIGNMENT!A1,ASSIGNMENT!$B1,IF(WORK!A1=ASSIGNEMTN!A2,ASSIGNEMNT!B$2,"Canno
find")

 

[BrianB]

Have a look at the =VLOOKUP() worksheet function.