Finding cell contents based on certain criteria

[thekovinc]

Hi, I have a problem that I can't quite seem to solve.

I have a table of data, with names across the top in a header row and
different categories as a "header column" (meaning to the left of the
data in the table).

i.e.:

Category Jason Nick Josh Bryan . . .
Age 20 45 17 68
Fav. # 08 07 23 22

 

[Tom Ogilvy]

Could you restate you question. It is unclear what you are asking.