View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default VLOOKUP and HLOOKUP

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