I am trying to pull pricing data from a larger workbook (masterprice.xlsx) for a new basic "price quote" workbook. The large workbook has a different sheet for each model name. In my new workbook, I would like to take the data for a given cell depending on what model I am working with. I was hoping, for example in the new sheet that if A2 is "Model A" (ideally this would be selected from a pulldown menu-but that is not quite the step I am at yet or exactly what I am asking here), then B2 take the corresponding price from the other workbook, so B2 would be set to ='[masterprice.xlsx]MODEL A'!$S$23 .
My question is, if A2 could be either "Model A", "Model B", or "Model C" (probably about 50 different sheets in total), what do I make the formula for B2? Instead of MODEL A is there a "text variable" (?) I would put in its place?
Sorry if this is unclear it is a little hard to explain. Any help appreciated.