View Full Version : Solved: Using data validation to return values

05-22-2010, 04:40 AM
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.


05-22-2010, 10:30 AM
I imagine there is a relationship between these items. What is it?

05-22-2010, 12:02 PM
Not sure either, of what the User is chasing Malcolm. Perhaps its the value in cell CA2.

05-23-2010, 07:37 AM
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!!

05-23-2010, 08:52 AM
=HLOOKUP(CONCATENATE(C3," ",C4," ",C5," ",C6),Costs!1:2,2,FALSE)

05-23-2010, 10:02 AM
Not only did that work, I completely understand why it worked! Thank you very much.