gaurav4698
New Member
- Joined
- Sep 12, 2014
- Messages
- 8
How can apply vlookup formula to get value from 3 or more arrays ?
Please help
Please help
ITEM | NAME | ITEM | NAME | ITEM | NAME | ||
itemA1 | A1 | itemB1 | B1 | itemC1 | C1 | ||
itemA2 | A2 | itemB2 | B2 | itemC2 | C2 | ||
itemA3 | A3 | itemB3 | B3 | itemC3 | C3 | ||
itemA4 | A4 | itemB4 | B4 | itemC4 | C4 | ||
ITEM | itemB1 | ||||||
NAME |
=IFERROR(VLOOKUP(a7,a2:b5,2,0),IFERROR(VLOOKUP(a7,d2:e5,2,0),IFERROR(VLOOKUP(a7,g2:h5,2,0),""))) |
=LOOKUP(REPT("z".255),CHOOSE({1,2,3,4},"",VLOOKUP("ItemB1",A:B,2,0),
VLOOKUP("ItemB1",C:D,2,0),VLOOKUP("ItemB1",E:F,2,0)))
Thanks for the help Aladin your solution worked fine.