|
A |
B |
C |
1 |
Name |
Qty |
Expected Result |
2 |
KeHE |
2 |
=IFERROR(VLOOKUP(A2,G2:H6,2,FALSE)&B2,B2) |
3 |
Def |
25 |
=IFERROR(VLOOKUP(A3,G3:H7,2,FALSE)&B3,B3) |
4 |
Abc |
65 |
=IFERROR(VLOOKUP(A4,G4:H8,2,FALSE)&B4,B4) |
5 |
|
|
=IFERROR(VLOOKUP(A5,G5:H9,2,FALSE)&B5,B5) |
6 |
|
|
=IFERROR(VLOOKUP(A6,G6:H10,2,FALSE)&B6,B6) |
7 |
|
|
=IFERROR(VLOOKUP(A7,G7:H11,2,FALSE)&B7,B7) |
8 |
|
|
=IFERROR(VLOOKUP(A8,G8:H12,2,FALSE)&B8,B8) |
9 |
|
|
=IFERROR(VLOOKUP(A9,G9:H13,2,FALSE)&B9,B9) |
10 |
|
|
=IFERROR(VLOOKUP(A10,G10:H14,2,FALSE)&B10,B10) |
11 |
|
|
=IFERROR(VLOOKUP(A11,G11:H15,2,FALSE)&B11,B11) |
12 |
|
|
=IFERROR(VLOOKUP(A12,G12:H16,2,FALSE)&B12,B12) |
13 |
|
|
=IFERROR(VLOOKUP(A13,G13:H17,2,FALSE)&B13,B13) |
14 |
|
|
=IFERROR(VLOOKUP(A14,G14:H18,2,FALSE)&B14,B14) |
15 |
|
|
=IFERROR(VLOOKUP(A15,G15:H19,2,FALSE)&B15,B15) |
Bookmarks