Two tables values with diffrent order and number of values
Solved/Closed
Edendolevberti
-
Oct 31, 2016 at 06:22 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 1, 2016 at 06:38 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 1, 2016 at 06:38 AM
Related:
- Two tables values with diffrent order and number of values
- School time table class wise and teacher wise software free - Download - Organisation and teamwork
- If statement to add values - Guide
- How to delete part of a table in word - Guide
- How to compare two columns and return values from the third ✓ - Excel Forum
- If contains multiple values excel ✓ - Excel Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 31, 2016 at 03:13 PM
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 1, 2016 at 06:38 AM
Nov 1, 2016 at 06:38 AM
Thanks for the feedback.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Nov 1, 2016 at 03:48 AM
It works!!!
Thanks alot
your the king in excel!! i tried to get it work a long time with no success, THANKS!!