Find an intersecting value in a range with two criteria

  • Thread starter Thread starter David
  • Start date Start date
D

David

I'll start this off with what I'm trying to describe is
like a football board. One teams numbers on the top row
and one teams numbers down a side column. I want to find
an intersecting number in the whole list.

What I'm actually trying to create is a fitness chart
where I can take a person's height in one cell their body
mass index in another and use these two references to find
a set percentage value (text cell with say 37% typed in)
in a table in another worksheet. One formula that worked
in getting data from two separate columns in a worksheet
was =LOOKUP(D39,'Male Tables'!$E$10:$E$103,'Male Tables'!
$F$10:$F$1030, but this is no good for a range of numbers
say from A1 down to A150 and from A1 to AO1.

I think I'm looking for a GetPivotData formula, but I'm
just not getting how it works. My table looks like this:

60.0 60.5 61.0 61.5 62.0

22.00 37% 37% 36% 36% 35%
22.25 36% 36% 35% 35% 34%
22.50
22.75
23.00

and so on.

ANY help would be greatly appreciated!

David Churchill, MSgt, MNANG
(e-mail address removed)
 
Jason, Thank you very much for the reply. I understand
what you're getting at here, but don't know what the A:A,0
and 1:1,0 are supposed to reference? When I try the
formula with my cell references I don't get any errors,
but I also don't get the data I want. I've tried to send
to you directly (work e-mail), but have been repeatedly
denied by your mail server as spam???
 
Back
Top