I'm trying to write a multiple (42) nested if statement but obviously excel will only allow me to input 8.

Basically I am writing a formula where I want the information to change based on the date which is cell $G$2. This is matched in a table of information where the columns headers are dates and the row headers are figures. So if I input a date on the spreadsheet it will find that date in the table and then give me a specific row with the information.


(IF($G$2=Sheet1!$F$4,Sheet1!F5,IF($G$2=Sheet1!$H$4,Sheet1!H5,IF($G$2=Sheet1!$J$4,Sheet1!J5,IF($G$2=Sheet1!$L$4,Sheet1!L5,IF($G$2=Sheet1!$N$4,Sheet1!N5,IF($G$2=Sheet1!$P$4,Sheet1!P5,IF($G$2=Sheet1!$R$4,Sheet1!R5,IF($G$2=Sheet1!$T$4,Sheet1!T5,)))))))))

This was the formulae I was using until I realised there was a limit on the nested if statements

Has anyone any ideas for a different function or alternative method.

Thanks