Nested IF too long? Need solution?

Hi,

I currently have a nested IF statement as follows..

=IF(Q64="D", IF($X$50="E-On", PricesComparison_Data!F6, IF($X$50="British Gas", PricesComparison_Data!F7, IF($X$50="EDF", PricesComparison_Data!F8, IF($X$50="GDF SVEZ", PricesComparison_Data!F9, )))))

What this does is in Q64 is a dropdown with either D or M as outcomes. If D is selected, then I want it to look at what has been selected in X50 and then bring through prices from the PriceComparison_Date sheet. Which this all does fine.

The problem is, I need to have the other outcome available to. So if the user selected M, then the same IF statement is performed, but instead of bringing values from say PriceComparison_Data!F9, it would bring the value in PriceComparison_Data!G9. So all the F columns would shift to G columns.

Does this make sense? Is it possible?

Cheers
Will

Seems to me most of your IF statements could be reduced to a lookup, so you could have one if that determines which lookup is needed based on the value of Q64. General format would be:

=IF(Q64="D",VLOOKUP($X$50,$AA$1:$AC$10,2,FALSE),IF(Q64="M",VLOOKUP($X$50,$AA$1:$AC$10,3,FALSE),""))

Then put a table that has the possible values for X50 in column AA, results for if it's D in column AB, and results for if it's M in column AC.