VLOOKUP and HLOOKUP
Dave, Jan, M Kan,
Thank you all! The speed and replies are great thank you.
Mike
"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
|