Two tables values with diffrent order and number of values [Solved/Closed]

Report
-
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
Hello,
I have 2 tables of products (diffrent number of products).
1st table contains: all products (name, SKU):
NAME | SKU
asd.........21398763
ads.........19386773
dda.........12974628
sad.........18277739

2nd table contains: about 60% of the products (name, SKU, qty sold):
NAME |SKU |SOLD
asd.........21398763.........60
ads.........19386773.........20
sad.........18277739.........38

i want to add the 'qty sold' value next to the matchable name on the first table.
Thank you very much in advance!

2 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
Edendolevberti, Good afternoon.

Suppose:

1st table:
A2:A5 --> NAME
B2:B5 --> SKU

2st table:
I2:I4 --> NAME
J2:J4 --> SKU
K2:K4 --> SOLD

Try to use:

C2 --> =IFERROR( VLOOKUP(A2, $I$2:$K$4, 3, FALSE), "")

Copy it down as necessary.

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3952 users have said thank you to us this month


WOW!!
It works!!!
Thanks alot
your the king in excel!! i tried to get it work a long time with no success, THANKS!!
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
Thanks for the feedback.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão