Two tables values with diffrent order and number of values

Solved/Closed
Edendolevberti - Oct 31, 2016 at 06:22 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Nov 1, 2016 at 06:38 AM
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

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Oct 31, 2016 at 03:13 PM
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
Edendolevberti
Nov 1, 2016 at 03:48 AM
WOW!!
It works!!!
Thanks alot
your the king in excel!! i tried to get it work a long time with no success, THANKS!!
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Nov 1, 2016 at 06:38 AM
Thanks for the feedback.

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