using a method to select which data source to choose

**Tradesman** · 11-20-2012, 02:46 PM

On the attached sheet is a vforecast which estimates the remaing stock based upon a forecast

In one instance I have my forecast ( eg an amended version ) but also at times i want to use my customers forecast.

is there an easy way to toggle the two data sources??

Im trying to reduce the no. of rows of data as I have a number of products and it may be easier just to toggle between them to identify where i may have a conflict eg a difference that is substantial that i should investigate...

Unless you can see an easier way to compare them !!

product follower complicated! v4.xlsx

Thnaks for all you ehelp guys(+gals) Ive learnt loads since Ive been on here and that for only a fortnight!

**FDibbins** · 11-20-2012, 05:27 PM

hi, try this...
in F7, i created a dropdown (data validation) using the 2 sheet names, youi can put this anywhere you want, just change the reference in in this formula, which pulls from the specified sheet...

=INDEX(INDIRECT("'"&Range!$F$7&"'!$A$1:$BB$200"),MATCH(Range!$E6,INDIRECT("'"&Range!$F$7&"'!$A$1:$A$200"),0),MATCH(Range!J$4,INDIRECT("'"&Range!$F$7&"'!$A$1:$BB$1"),0))

**Tradesman** · 11-21-2012, 08:27 AM

Hi where do I add the 2 sheet names- could you amend the formual to read XXXX for one sheet and YYYY for the other -thanks!

**Tradesman** · 11-21-2012, 11:08 AM

sorry being completly thivk- i thought through the process a little longer over a cup of tea- thanks superb!

would you break the formula down so i can understand the logic?