Hi, I am trying to create a formula that will intially look up a cell that has a drop down list with 3 answers, depending on the selected dropdown it needs to do a vlookup on the relevant tab to the drop down list.
I have currently tried writing something along the lines of the below without success.
IF(b3="High Sales",VLOOKUP($C$17,'HIGH SALES CURVES'!$A:$CI,B$20,0)),IF(b3="Standard Sales"VLOOKUP($C$17,'STANDARD SALES CURVES'!$A:$CI,B$20,0)), IF(b3="Low Sales",VLOOKUP($C$17,'LOW SALES CURVES'!$A:$CI,B$20,0))
This currently works on a single tab without the dropdown as below but need to have a few different options.
=VLOOKUP($C$17,'STANDARD SALES CURVES'!$A:$CI,B$20,0)
If you could help me with this it would be much appreciated.
Thanks
I have currently tried writing something along the lines of the below without success.
IF(b3="High Sales",VLOOKUP($C$17,'HIGH SALES CURVES'!$A:$CI,B$20,0)),IF(b3="Standard Sales"VLOOKUP($C$17,'STANDARD SALES CURVES'!$A:$CI,B$20,0)), IF(b3="Low Sales",VLOOKUP($C$17,'LOW SALES CURVES'!$A:$CI,B$20,0))
This currently works on a single tab without the dropdown as below but need to have a few different options.
=VLOOKUP($C$17,'STANDARD SALES CURVES'!$A:$CI,B$20,0)
If you could help me with this it would be much appreciated.
Thanks