2 list matching

Closed
phph - Jan 12, 2015 at 01:07 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 13, 2015 at 12:13 AM
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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 13, 2015 at 12:13 AM
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
0