Nested Formula Issue

=IF(F1="Mar 2",VLOOKUP("100 AA 14",'Mar 2 Data By Seat'!A2:AH488,31,FALSE),IF(F1="Mar 3",VLOOKUP("100 AA 14",'Mar 3 Data By Seat'!A2:AH585,31,FALSE),IF(F1="Mar 5",VLOOKUP("100 AA 14",'Mar 5 Data By Seat'!A2:AH570,31,FALSE),IF(F1="Mar 8",VLOOKUP("100 AA 14",'Mar 8 Data By Seat'!A2:AH542,31,FALSE),IF(F1="Mar 9",VLOOKUP("100 AA 14",'Mar 9 Data By Seat'!A2:AH601,31,FALSE),IF(F1="Mar 12",VLOOKUP("100 AA 14",'Mar 12 Data By Seat'!A2:AH554,31,FALSE),IF(F1="Mar 14",VLOOKUP("100 AA 14",'Mar 14 Data By Seat'!A2:AH663,31,FALSE))))))))

In F1 I have created a drop down box that has a date for every game day. Depending on what the date in the drop down box shows I want the cell to go to that's date sheet and look up the price that seat was sold for. The issue is I have 6 If statements above, one with a vlookup in it for each date. I have about 22 total dates in the drop down box but if I add anymore if statements I will receive a nesting error. Any ideas on how I would be able to fix that issue?

That might work for you:

=VLOOKUP("100 AA 14",indirect("'"&F1&" Data By Seat'!A2:AH5000"),31,FALSE)

That worked perfectly! Thank you!

Hi All,

=IF(AND((AB3="Over 5YR"),(U3="AZN"),(M3="Corporate")),$K$3,IF(AND((AB3="Over 5YR"),(U3="AZN"),(M3="Commercial")),$K$9,IF(AND((AB3="Over 5YR"),(U3="AZN"),(M3="Business")),$K$15,IF(AND((AB3="Over 5YR"),(U3="AZN"),(M3="Private Banking")),$K$21,IF(AND((AB3="5YR"),(U3="AZN"),(M3="Corporate")),$J$3,IF(AND((AB3="5YR"),(U3="AZN"),(M3="Commercial")),$J$9,IF(AND((AB3="5YR"),(U3="AZN"),(M3="Business")),$J$15,IF(AND((AB3="5YR"),(U3="AZN"),(M3="Private Banking")),$J$21,IF(AND((AB3="4YR"),(U3="AZN"),(M3="Corporate")),$I$3,IF(AND((AB3="4YR"),(U3="AZN"),(M3="Commercial")),$I$9,IF(AND((AB3="4YR"),(U3="AZN"),(M3="Business")),$I$15,IF(AND((AB3="4YR"),(U3="AZN"),(M3="Private Banking")),$I$21,IF(AND((AB3="3YR"),(U3="AZN"),(M3="Corporate")),$H$3,IF(AND((AB3="3YR"),(U3="AZN"),(M3="Commercial")),$H$9,IF(AND((AB3="3YR"),(U3="AZN"),(M3="Business")),$H$15,IF(AND((AB3="3YR"),(U3="AZN"),(M3="Private Banking")),$H$21,IF(AND((AB3="2YR"),(U3="AZN"),(M3="Corporate")),$G$3,IF(AND((AB3="2YR"),(U3="AZN"),(M3="Commercial")),$G$9,IF(AND((AB3="2YR"),(U3="AZN"),(M3="Business")),$G$15,IF(AND((AB3="2YR"),(U3="AZN"),(M3="Private Banking")),$G$21,IF(AND((AB3="1YR"),(U3="AZN"),(M3="Corporate")),$F$3,IF(AND((AB3="1YR"),(U3="AZN"),(M3="Commercial")),$F$9,IF(AND((AB3="1YR"),(U3="AZN"),(M3="Business")),$F$15,IF(AND((AB3="1YR"),(U3="AZN"),(M3="Private Banking")),$F$21,IF(AND((AB3="6M"),(U3="AZN"),(M3="Corporate")),$E$3,IF(AND((AB3="6M"),(U3="AZN"),(M3="Commercial")),$E$9,IF(AND((AB3="6M"),(U3="AZN"),(M3="Business")),$E$15,IF(AND((AB3="6M"),(U3="AZN"),(M3="Private Banking")),$E$21,IF(AND((AB3="3M"),(U3="AZN"),(M3="Corporate")),$D$3,IF(AND((AB3="3M"),(U3="AZN"),(M3="Commercial")),$D$9,IF(AND((AB3="3M"),(U3="AZN"),(M3="Business")),$D$15,IF(AND((AB3="3M"),(U3="AZN"),(M3="Private Banking")),$D$21,IF(AND((AB3="1M"),(U3="AZN"),(M3="Corporate")),$C$3,IF(AND((AB3="1M"),(U3="AZN"),(M3="Commercial")),$C$9,IF(AND((AB3="1M"),(U3="AZN"),(M3="Business")),$C$15,IF(AND((AB3="1M"),(U3="AZN"),(M3="Private Banking")),$C$21,IF(AND((AB3="Over 5YR"),(U3="USD"),(M3="Corporate")),$K$3,IF(AND((AB3="Over 5YR"),(U3="USD"),(M3="Commercial")),$K$9,IF(AND((AB3="Over 5YR"),(U3="USD"),(M3="Business")),$K$15,IF(AND((AB3="Over 5YR"),(U3="USD"),(M3="Private Banking")),$K$21,IF(AND((AB3="5YR"),(U3="USD"),(M3="Corporate")),$J$3,IF(AND((AB3="5YR"),(U3="USD"),(M3="Commercial")),$J$9,IF(AND((AB3="5YR"),(U3="USD"),(M3="Business")),$J$15,IF(AND((AB3="5YR"),(U3="USD"),(M3="Private Banking")),$J$21,IF(AND((AB3="4YR"),(U3="USD"),(M3="Corporate")),$I$3,IF(AND((AB3="4YR"),(U3="USD"),(M3="Commercial")),$I$9,IF(AND((AB3="4YR"),(U3="USD"),(M3="Business")),$I$15,IF(AND((AB3="4YR"),(U3="USD"),(M3="Private Banking")),$I$21,IF(AND((AB3="3YR"),(U3="USD"),(M3="Corporate")),$H$3,IF(AND((AB3="3YR"),(U3="USD"),(M3="Commercial")),$H$9,IF(AND((AB3="3YR"),(U3="USD"),(M3="Business")),$H$15,IF(AND((AB3="3YR"),(U3="USD"),(M3="Private Banking")),$H$21,IF(AND((AB3="2YR"),(U3="USD"),(M3="Corporate")),$G$3,IF(AND((AB3="2YR"),(U3="USD"),(M3="Commercial")),$G$9,IF(AND((AB3="2YR"),(U3="USD"),(M3="Business")),$G$15,IF(AND((AB3="2YR"),(U3="USD"),(M3="Private Banking")),$G$21,IF(AND((AB3="1YR"),(U3="USD"),(M3="Corporate")),$F$3,IF(AND((AB3="1YR"),(U3="USD"),(M3="Commercial")),$F$9,IF(AND((AB3="1YR"),(U3="USD"),(M3="Business")),$F$15,IF(AND((AB3="1YR"),(U3="USD"),(M3="Private Banking")),$F$21,IF(AND((AB3="6M"),(U3="USD"),(M3="Corporate")),$E$3,IF(AND((AB3="6M"),(U3="USD"),(M3="Commercial")),$E$9,IF(AND((AB3="6M"),(U3="USD"),(M3="Business")),$E$15,IF(AND((AB3="6M"),(U3="USD"),(M3="Private Banking")),$E$21,IF(AND((AB3="3M"),(U3="USD"),(M3="Corporate")),$D$3,IF(AND((AB3="3M"),(U3="USD"),(M3="Commercial")),$D$9,IF(AND((AB3="3M"),(U3="USD"),(M3="Business")),$D$15,IF(AND((AB3="3M"),(U3="USD"),(M3="Private Banking")),$D$21,IF(AND((AB3="1M"),(U3="USD"),(M3="Corporate")),$C$3,IF(AND((AB3="1M"),(U3="USD"),(M3="Commercial")),$C$9,IF(AND((AB3="1M"),(U3="USD"),(M3="Business")),$C$15,IF(AND((AB3="1M"),(U3="USD"),(M3="Private Banking")),$C$21,IF(AND((AB3="Over 5YR"),(U3="EUR"),(M3="Corporate")),$K$3,IF(AND((AB3="Over 5YR"),(U3="EUR"),(M3="Commercial")),$K$9,IF(AND((AB3="Over 5YR"),(U3="EUR"),(M3="Business")),$K$15,IF(AND((AB3="Over 5YR"),(U3="EUR"),(M3="Private Banking")),$K$21,IF(AND((AB3="5YR"),(U3="EUR"),(M3="Corporate")),$J$3,IF(AND((AB3="5YR"),(U3="EUR"),(M3="Commercial")),$J$9,IF(AND((AB3="5YR"),(U3="EUR"),(M3="Business")),$J$15,IF(AND((AB3="5YR"),(U3="EUR"),(M3="Private Banking")),$J$21,IF(AND((AB3="4YR"),(U3="EUR"),(M3="Corporate")),$I$3,IF(AND((AB3="4YR"),(U3="EUR"),(M3="Commercial")),$I$9,IF(AND((AB3="4YR"),(U3="EUR"),(M3="Business")),$I$15,IF(AND((AB3="4YR"),(U3="EUR"),(M3="Private Banking")),$I$21,IF(AND((AB3="3YR"),(U3="EUR"),(M3="Corporate")),$H$3,IF(AND((AB3="3YR"),(U3="EUR"),(M3="Commercial")),$H$9,IF(AND((AB3="3YR"),(U3="EUR"),(M3="Business")),$H$15,IF(AND((AB3="3YR"),(U3="EUR"),(M3="Private Banking")),$H$21,IF(AND((AB3="2YR"),(U3="EUR"),(M3="Corporate")),$G$3,IF(AND((AB3="2YR"),(U3="EUR"),(M3="Commercial")),$G$9,IF(AND((AB3="2YR"),(U3="EUR"),(M3="Business")),$G$15,IF(AND((AB3="2YR"),(U3="EUR"),(M3="Private Banking")),$G$21,IF(AND((AB3="1YR"),(U3="EUR"),(M3="Corporate")),$F$3,IF(AND((AB3="1YR"),(U3="EUR"),(M3="Commercial")),$F$9,IF(AND((AB3="1YR"),(U3="EUR"),(M3="Business")),$F$15,IF(AND((AB3="1YR"),(U3="EUR"),(M3="Private Banking")),$F$21,IF(AND((AB3="6M"),(U3="EUR"),(M3="Corporate")),$E$3,IF(AND((AB3="6M"),(U3="EUR"),(M3="Commercial")),$E$9,IF(AND((AB3="6M"),(U3="EUR"),(M3="Business")),$E$15,IF(AND((AB3="6M"),(U3="EUR"),(M3="Private Banking")),$E$21,IF(AND((AB3="3M"),(U3="EUR"),(M3="Corporate")),$D$3,IF(AND((AB3="3M"),(U3="EUR"),(M3="Commercial")),$D$9,IF(AND((AB3="3M"),(U3="EUR"),(M3="Business")),$D$15,IF(AND((AB3="3M"),(U3="EUR"),(M3="Private Banking")),$D$21,IF(AND((AB3="1M"),(U3="EUR"),(M3="Corporate")),$C$3,IF(AND((AB3="1M"),(U3="EUR"),(M3="Commercial")),$C$9,IF(AND((AB3="1M"),(U3="EUR"),(M3="Business")),$C$15,IF(AND((AB3="1M"),(U3="EUR"),(M3="Private Banking")),$C$21

I have this formula and excell doesn't accept it as it is not allowed to use more than 64 nesting..
Could you please somehow simplify this formula?

Thanks in advance