[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]I copied the formula from a similar one in another thread here, but keeping getting either "too few arguments" or "closing parenthesis". Help?
IFERROR(IF(I3="AVG",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,22,FALSE),IF(I3="P1/CY Avg",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,23,FALSE),IF(I3="40/60",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,24,FALSE),IF(I3="30/70",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,25,FALSE),IF(I3="20/80",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,26,FALSE))))))[/TD]
[/TR]
</tbody>[/TABLE]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]I copied the formula from a similar one in another thread here, but keeping getting either "too few arguments" or "closing parenthesis". Help?
IFERROR(IF(I3="AVG",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,22,FALSE),IF(I3="P1/CY Avg",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,23,FALSE),IF(I3="40/60",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,24,FALSE),IF(I3="30/70",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,25,FALSE),IF(I3="20/80",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,26,FALSE))))))[/TD]
[/TR]
</tbody>[/TABLE]