Solved: Using data validation to return values

[Grilleman]

Attached is a workbook containing two worksheets: The "Selector" worksheet and the “Cost” worksheet. When I complete the blue input fields on the “Selector” worksheet I want the resulting "Base Cost" to be displayed in the yellow highlighted field. All base costs are stored on the “Costs” sheet.

Thanks!

[mdmackillop]

I imagine there is a relationship between these items. What is it?

[Aussiebear]

Not sure either, of what the User is chasing Malcolm. Perhaps its the value in cell CA2.

[Grilleman]

Yes - Bsed on the inputs in the sample "Selector" worksheet, the value I'm after is indeed contained in CA2 on the "Cost" worksheet.

Be aware that I posted a similar request on 3-3-2010 entiled "Conditional Drop Down Lists" which was answered by "xld" (a mentor). See "xld's" reply- specifically on the Excel worksheet's menu... choose Data>Validation and see his formula.

Thanks for the help!!

[mdmackillop]

=HLOOKUP(CONCATENATE(C3," ",C4," ",C5," ",C6),Costs!1:2,2,FALSE)

[Grilleman]

Not only did that work, I completely understand why it worked! Thank you very much.