Excel argument is too long. What should I do?

=IF(AW3="January",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,2,FALSE),IF(AW3="February",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,3,FALSE),IF(AW3="March",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,4,FALSE),IF(AW3="April",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,5,FALSE),IF(AW3="May",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,6,FALSE),IF(AW3="June",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,7,FALSE),IF(AW3="July",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,8,FALSE),IF(AW3="August",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,9,FALSE),IF(AW3="September",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,10,FALSE,IF(AW3="October",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,11,FALSE),IF(AW3="November",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,12,FALSE),IF(AW3="December",VLOOKUP(TRIM(AH3),'Average Price'!$A$1:$M$291,13,FALSE),))))))))))

I have defined the months so January = 1 feb=2 and so on...... and aw3 is the month in text form

Thank You it worked great can you explain the last part of the formula to me "MONTH(1 & AW3) + 1, FALSE".

Originally Posted by shg

Maybe ...

=VLOOKUP(TRIM(AH3), 'Average Price'!$A$1:$M$291, MONTH(1 & AW3) + 1, FALSE)