Help With IF and V-Lookup on multiple sheets

[joegolfdad]

I am attempting to create a IF-VLookup functions that crosses multiple sheets. In column I is the type of client, and in column G is the total sales. If the type of client is personal, I need to reference a vlookup table on a different sheet. If the client is corporate, i need to reference another vlookup table on that other sheet that is different than the vlookup table used for personal clients.

My problem is when I attempt to reference the column number on the different sheet. It comes in as sheetname!2, which is invalid.

=IF(I2="Personal",VLOOKUP(SalesHistory[[#Headers],[Total Sales]],ClientClassification!$B$11:$C$13,2,FALSE),VLOOKUP([@[Total Sales]],ClientClassification!$B$19:$C$21,2,FALSE))

That is what I have right now, essentially two nested vlookup functions.

Any help would be greatly appreciated.

 

[buxtongt]

It looks like that first vlookup has too many arguments in it. I see 4 commas and you should only have 3 to separate the 4 arguments you need. Hope this helps.