Help on vlookup formula and data

[pcrew]

i have attached my sample spreadsheet to this thread and was wondering if i could get assistance in this.

Details:
Workbook has following sheets:
"equipment List" and "vlookup data"

"equipment list" has following fields where cost is the field that needs the vlookup data value.

model, building, cost

"vlookup data" has following fields in 2 different ranges.
range1
manfacturer, model, cost-usa, cost-canada,cost-england
range2
building, country

requirement is that "cost" field in "equipment list should have the value based on the model and cost with respect to the building value.

i can do simple vlookup to get "a cost-country" value but fail to understand how to ensure the value comes from the correct cost-country column based on the building info.

[JBeaucaire]

Take a look, does this do what you want?

[pcrew]

JBeaucaire

Thanks for the quick response and help on this. that worked completely.

Note: The formula in "equipment list" cell E-2 is incorrect but i was able to use the one from E3 and it works like a charm.

I am really glad i found this forum thru google and the team here is really awesome. I will contribute in all possible ways i can to help out others.