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