formula question

[hschussler]

Is there a quicker way to write this formula rathe than clicking on each cell?

thanks,


=IF(($J$18=1),F36,if($J$18=2),G36,if($J$18=3),H36,if($J$18=4),I36,if($J$18=5),J36,if($J$18=6),K36,if($J$18=7),L36,if($J$18=8),M36,if($J$18=9),N36,if($J$18=10),O36,"")

 

[MBinMTL]

if J18 only ever contains a value between 1 and 10 try this: still have to click on each cell but it's easier to write

=CHOOSE($J$18,F36,G36,H36,I36,J36,K36,L36,M36,N36,O36)

 

[Richard Schollar]

If that was the case you could use:

=INDEX(F36:O36,J18)