.. all the data is within the same spreadsheet

Data Filter Autofilter
seems the natural* fit here to achieve what you're after

*Also the easiest, as the autofilter dropdowns on the 4 key cols
will give your users the unique selections in the dropdowns

The ultimate filtered row(s) satisfying all 4 key col selections
will be the result line(s).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vince" wrote:
Hi all,

I want to modify a spreadsheet so that the user picks 1 variable from 4
different columns
and a cell that has the value equivalent to these 4 conditions is
automatically highlighted - all the data is within the same spreadsheet

For example, if you pick item A (variable 1), order 100 (variable 2
etc.)....then the value of this item is $100 (highlight this cell)

Thanks