2 list matching

Closed
phph - 12 Jan 2015 à 13:07
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 13 Jan 2015 à 00:13
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
13 Jan 2015 à 00:13
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