IF statements and VLOOKUP

[Woody23]

Hello,

I am currently trying to build a file that will pull different numbers on different tables using IF and VLOOKUP. I currently have it pulling the correct numbers for just two tables but I have several more tables to use. I am getting an error saying Im using too many arguements.

=IF(B4=150,VLOOKUP(B3,'sheet2'!B3:U23,3),IF(B4=300,'sheet2'!B28:U48,3),IF(B4=400,'sheet2'!B53:R73,3)))

I also have to get values for 5 more tables. What's the best way to approach this?

[Pete_UK]

You need to have VLOOKUP for the middle and third IF, as well as having a FALSE value if none of the IFs are met:

=IF(B4=150,VLOOKUP(B3,'sheet2'!B3:U23,3),IF(B4=300,VLOOKUP(B3,'sheet2'!B28:U48,3),IF(B4=400,VLOOKUP(B3,'sheet2'!B53:R73,3),"")))

Hope this helps.

Pete