Hello I'm working on a spreadsheet and using multiply IF statements within one cell - I'm hoping someone can direct me on a more simple way to do it. Below is an example of the IF statements using - I have to look up 200 different cell combinations:
IF($A$3=1,"SELECT PRODUCT",IF($A$3=2,AU2,IF($A$3=3,AU3,IF($A$3=4,AU4,IF($A$3=5,AU5,IF($A$3=6,AU6,IF($A$3=7,AU7,IF($A$3=8,AU8,IF($A$3=9,AU9,IF($A$3=10,AU10,AN2))))))))))
Thank you, in advance, for your assistance.
Regards,
Mary
Bookmarks