If I understand it correctly, you basically are looking for a single
value if given a value in the column and a value in a row (like a
multiplication table). In that case, you can use the following
formula:

in general:
=INDEX(table range including headers,MATCH(value in column,column
range,0),MATCH(row value,row range,0))

in your case:
=INDEX($BP$4:$CU$32,MATCH(value in column,$BP$4:$BP$32,0),MATCH(row
value,$BP$4:$CU$4,0))

...where "value in column" and "value in row" are the inputs to get an
intersection data point. You can make them cell sepcific so a user can
type the row value in A1 and column value in A2.

Hope this helps,
Phillycheese


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=480109