Comparing two lists and return specified data
 

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

Comparing two lists and return specified data
 

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

Comparing two lists and return specified data
 

THANK YOU Bernie!!
Worked like a charm!!!
--
Clement E


"Bernie Deitrick" wrote:

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