IF Vlookup error problem

[sjuhl99]

I am trying to finish this IF vlookup statement and keep getting a to many arguments error, can someone please help me? Its basically just saying if F3=1,2,3 or 4 then lookup from another workbook, seems simple enough but I cant seem to get it. thanks



=IFERROR(AND(f3=1,VLOOKUP('Locked Forecasts-DNT'!A2:AH11240,35,0),IF(f3=2,VLOOKUP('Locked Forecasts-DNT'!W2:AI11240,37,0),IF(f3=3,VLOOKUP('Locked Forecasts-DNT'!A2:AJ11240,38,0),IF(f3=4,'Locked Forecasts-DNT'!A2:AK11240,39,0),"0"))

 

[Aladin Akyurek]

=INDEX('Locked Forecasts-DNT'!AH2:AK11240,MATCH(lookupvalue,'Locked Forecasts-DNT'!A2:A11240,0),F3)

Note that the nonworking formula you posted does not show what the lookupvalue is...