Nested IF too long? Need solution?

Hi,

I currently have a nested IF statement as follows..

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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.