software

I need to be able to compare two lists and then move data from one to the
other if records are matched.
For example, I need to fill in Ben's State in My List but only if there is a
match in the Reference List.

My List:
Column A Column B
Name State
Ben

Reference List:
Column A Column B
Name State
Ben FL

I used the MATCH and VLOOKUP functions but has not quite got the job done
Please help!
--
Clement E

maybe

=if(isna(vlookup(A2,StateRange,2,1),quot;quot;,vlookup(A2, StateRange,2,1))

quot;Clementquot; wrote:

gt; I need to be able to compare two lists and then move data from one to the
gt; other if records are matched.
gt; For example, I need to fill in Ben's State in My List but only if there is a
gt; match in the Reference List.
gt;
gt; My List:
gt; Column A Column B
gt; Name State
gt; Ben
gt;
gt; Reference List:
gt; Column A Column B
gt; Name State
gt; Ben FL
gt;
gt; I used the MATCH and VLOOKUP functions but has not quite got the job done
gt; Please help!
gt; --
gt; Clement E

It was worth a try even though it did not work. I did however get the correct
function from a previous post I made which I thought did not go through. Its
under the same heading title. Thanks for the response though...
--
Clement Equot;Duke Careyquot; wrote:

gt; maybe
gt;
gt; =if(isna(vlookup(A2,StateRange,2,1),quot;quot;,vlookup(A2, StateRange,2,1))
gt;
gt; quot;Clementquot; wrote:
gt;
gt; gt; I need to be able to compare two lists and then move data from one to the
gt; gt; other if records are matched.
gt; gt; For example, I need to fill in Ben's State in My List but only if there is a
gt; gt; match in the Reference List.
gt; gt;
gt; gt; My List:
gt; gt; Column A Column B
gt; gt; Name State
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 used the MATCH and VLOOKUP functions but has not quite got the job done
gt; gt; Please help!
gt; gt; --
gt; gt; Clement E