INDEX-MATCH is always a good one. If you have a discrete set of Heights and
Weights, you can also use combo boxes and the INDEX function or pair up a
VLOOKUP/HLOOKUP with a variable Column reference
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Dave Peterson" wrote:

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