BenjieLop
Column A has the Populations per acre A2:A6 (115 thru 95). A1 has
nothing in it.
Row 1 has the row with in B1:G1 (40 thru 30)
=INDEX($A$2:$A$6,MATCH(J2,OFFSET($A$1,MATCH(J1,$B$ 1:$G$1,0),5,1),0))
This is what I have in my sample. Is it differant from yours?
Thanks for trying
Joe


--
JoeBed
------------------------------------------------------------------------
JoeBed's Profile: http://www.excelforum.com/member.php...o&userid=21368
View this thread: http://www.excelforum.com/showthread...hreadid=376378