How can I lookup for data on another sheet based on what is selected on my drop down

[Marshall008]

Hello, Please I'm trying to make my price calculator to calculate price from the price list of the color selected.For example if white is selected, the calculator should make use of white price list to calculate. Thanks.

[CRIMEDOG]

1 - do not use spaces in your Tab Names - makes it harder to reference in formulas - I would suggest remove "shirt Prices" - then the choice in D11 will reflect the tab
2 - Try renaming your ranges WhiteFirst, DarkFirst, ColoredFirst

then when you index the range you can use Indirect($D$11&"First[1C]:[12C]") etc...

[Marshall008]

Thanks for the response. I changed some things on the calculator. Right now all the calculation are working the way I want,
the only thing disturbing me is: I want the calculator to calculate from the sheet of selected color.
For example, white color- calculation should be done on with the sheet "white".

Kindly assist me on how to do that, I'm a beginner at excel.

Thanks, looking forward to your response.

[maras_mak]

Replace the names of ranges:
First ---> White
First3 ---> Dark
In the cell 'I7' formula
=IFERROR(INDEX(INDIRECT($D$11&"[[1C]:[12C]]"); MATCH($D$9; INDIRECT($D$11&"[Break Point]"); 1); MATCH($D$10; INDIRECT($D$11&"[#Headers]"); 0)-1); 0)
Regards.

[Marshall008]

Thanks for your assistant, for the formula on the cell I7, I keep getting this error "There's a problem with this formula". please kindly assist me.

[maras_mak]

Sorry, change semicolons ';' to commas ','
I wrote this in the Polish version of excel and I did not exchange it, sorry

[Marshall008]

Thanks this solved my problems

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.