Two tables values with diffrent order and number of values
Solved/Closed
Edendolevberti
-
31 Oct 2016 à 06:22
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 1 Nov 2016 à 06:38
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 1 Nov 2016 à 06:38
Related:
- Two tables values with diffrent order and number of values
- Based on the values in cells b77 - Excel Forum
- How to delete part of a table in word - Guide
- Conditional formatting between two values ✓ - Excel Forum
- Oracle show tables - Guide
- Code to move rows into another sheet based on certain values ✓ - Excel Forum
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
31 Oct 2016 à 15:13
31 Oct 2016 à 15:13
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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
1 Nov 2016 à 06:38
1 Nov 2016 à 06:38
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
1 Nov 2016 à 03:48
It works!!!
Thanks alot
your the king in excel!! i tried to get it work a long time with no success, THANKS!!