View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike M[_2_] Mike M[_2_] is offline
external usenet poster
 
Posts: 12
Default 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