Too many arguments

[lewdow]

Hi, I am trying to use a VLOOKUP function to fetch a value from a table on sheet 2 dependant upon the value entered in cell D1. I have done it for the first two columns in the table on sheet 2, but when I try to enter more, it says i have too many arguments....any ideas?

The formula I want to use goes something like....
=IF($D$1<=4,VLOOKUP(B3,'Sheet 2'!$A$4:$J$70,4,0),IF(AND($D$1>=5,$D$1<=19),VLOOKUP(B3,'Sheet 2'!$A$4:$J$70,5,0)),IF(AND($D$1>=20,$D$1<=49),VLOOKUP(B3,'Sheet 2'!$A$4:$J$70,6,0)),IF(AND($D$1>=50,$D$1<=199),VLOOKUP(B3,'Sheet 2'!$A$4:$J$70,7,0)),IF(AND($D$1>=200,$D$1<=349),VLOOKUP(B3,'Sheet 2'!$A$4:$J$70,8,0)),IF(AND($D$1>=350,$D$1<=1499),VLOOKUP(B3,'Sheet 2'!$A$4:$J$70,9,0)),IF($D$1>=1500),VLOOKUP(B3,'Sheet 2'!$A$4:$J$70,5,0))

Thanks

 

[Jonmo1]

Welcome to the board...

Try this..
=VLOOKUP(B3,'Sheet 2'!$A$4:$J$70,LOOKUP($D$1,{0,5,20,50,200,350,1500},{4,5,6,7,8,9,5}),FALSE)

Hope that helps

 

[lewdow]

thanks so much, you don't understand how frustrating it was trying to get that to work!