thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 956
- Office Version
- 365
- Platform
- Windows
I am having trouble with this formula. Any help is appreciated:
A VLOOKUP across 6 tables. Here is my formula but saying too many arguments:
=IFERROR(VLOOKUP(A2,Table_Fixtures,5,0),VLOOKUP(A2,Table_Lamps,4,0),VLOOKUP(A2,Table_Accessory,4,0),VLOOKUP(A2,Table_Controls,3,0),VLOOKUP(A2,Table_Materials,4,0),VLOOKUP(A2,Table_Rental,4,0))))))))
A VLOOKUP across 6 tables. Here is my formula but saying too many arguments:
=IFERROR(VLOOKUP(A2,Table_Fixtures,5,0),VLOOKUP(A2,Table_Lamps,4,0),VLOOKUP(A2,Table_Accessory,4,0),VLOOKUP(A2,Table_Controls,3,0),VLOOKUP(A2,Table_Materials,4,0),VLOOKUP(A2,Table_Rental,4,0))))))))