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



"Clement" wrote in message
...
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!

--
Clement E