Report

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

Ask a question Edendolevberti - Last answered on Nov 1, 2016 06:38AM
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!
See more 
Helpful
+2
moins plus
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
Edendolevberti- Nov 1, 2016 03:48AM
WOW!!
It works!!!
Thanks alot
your the king in excel!! i tried to get it work a long time with no success, THANKS!!
Reply
Add comment
Helpful
+0
moins plus
Thanks for the feedback.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!