Comparing two lists

C

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Drop down list control value in vba 2
Comparing two lists 0
comparing two columns in vba 2
Double Lookup 3
Comparing two lists in Excel 1
Match Copy/Paste Macro almost there 0

Top