Debra Dalgleish can.
http://contextures.com/xlFunctions03.html
Especially examples 2 and 3.
Mike M wrote:
Here is the scenario. I have a record with two values, for example: Height
and weight.
I need to reference a grid of data with standard heights on the Y axis
(first column) and standards weights across the top on the horizontal X axis
(row). Where the two intersect, going down then across (or vice versa) is
the value I need to retrieve.
Can anyone provide any assistance?
Thanks,
Mike
--
Dave Peterson