software

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

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
quot;Clementquot; gt; wrote in message
...
gt;I need to be able to compare two lists and return values from one to the
gt;other.
gt; For example if 'Ben' from My list is found in the Reference list, then
gt; autofill/return/extract/copy the value 'FL' into My list.
gt; My list
gt; Column A Column B
gt; Name
gt; Ben
gt;
gt; Reference list:
gt; Column A Column B
gt; Name State
gt; Ben FL
gt;
gt; I'ave used the MATCH and VLOOKUP functions, but its not quite getting the
gt; job done. Please help!
gt;
gt; --
gt; Clement E
THANK YOU Bernie!!
Worked like a charm!!!
--
Clement Equot;Bernie Deitrickquot; wrote:

gt; Clement,
gt;
gt; In cell BXXX of My List:
gt; =VLOOKUP(AXXX,ReferenceListAddressAbsolute,2,False )
gt;
gt; For example:
gt; =VLOOKUP(A2,'Sheet 2'!$A$1:$B$25,2,FALSE)
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt;
gt; quot;Clementquot; gt; wrote in message
gt; ...
gt; gt;I need to be able to compare two lists and return values from one to the
gt; gt;other.
gt; gt; For example if 'Ben' from My list is found in the Reference list, then
gt; gt; autofill/return/extract/copy the value 'FL' into My list.
gt; gt; My list
gt; gt; Column A Column B
gt; gt; Name
gt; gt; Ben
gt; gt;
gt; gt; Reference list:
gt; gt; Column A Column B
gt; gt; Name State
gt; gt; Ben FL
gt; gt;
gt; gt; I'ave used the MATCH and VLOOKUP functions, but its not quite getting the
gt; gt; job done. Please help!
gt; gt;
gt; gt; --
gt; gt; Clement E
gt;
gt;
gt;