2 list matching [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
i have 2 lists:

LIST 1
A1 B1
sku1 4.50
sku2 5.00
sku3 6.50
sku4 2.25
sku5 1.25


need to enter/match these B1 values into a similar, but not identical list in the b1 column

LIST 2
A1 B1
sku1 <no value>
sku3 <no value>
sku5 <no value>


so LIST 2 ends up looking like this:
sku1 4.50
sku3 6.50
sku5 1.25




any help?

thanks
pete

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
list 1 is in sheet1
list 2 in sheet2 only column A only

in sheet2 in B`1 type this formula

=VLOOKUP(A1,Sheet1!$A$1:$B$5,2,0)

copy this down