Comparing two lists and return specified data

G

Guest

I need to be able to compare two lists and return values from one to the other.
For example if 'Ben' from My list is found in the Reference list, then
autofill/return/extract/copy the value 'FL' into My list.
My list
Column A Column B
Name
Ben

Reference list:
Column A Column B
Name State
Ben FL

I'ave used the MATCH and VLOOKUP functions, but its not quite getting the
job done. Please help!
 
B

Bernie Deitrick

Clement,

In cell BXXX of My List:
=VLOOKUP(AXXX,ReferenceListAddressAbsolute,2,False)

For example:
=VLOOKUP(A2,'Sheet 2'!$A$1:$B$25,2,FALSE)

HTH,
Bernie
MS Excel MVP
 

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

Comparing two lists and extracting data from one to another 2
Compare Two Lists 1
XL2000 CF and Comparing Lists 5
How do I lookup multilple criteria and return a single value 1
Compare 2 lists and return value 2
If(not(A2="FL","AL".... ),"other",A2) IF(not help 3
Comparing two lists 3
Creating a Master List from sub-lists 4

Top