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

Report
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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 2942 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
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
Thanks for the feedback.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!