Hi Jeff,
When I use Index(Match) together I think of the formula this way:

=INDEX(Range to Search, ?, ?) where neither column or row are known and
therefore, ? becomes MATCH(Cell to Match, Range in which to search for match,
FALSE)

All together you get:

=INDEX(Range to Search,MATCH(Cell to Match, Range in which to search for
match, FALSE),MATCH(Cell to Match, Range in which to search for match, FALSE)

However, this will only get you a single cell and not the column heading.

I hope this helps.
-Nicole


" wrote:

Hello,
I'm trying to use the Match function to find a value in a large
table. I am able to get the match function to work looking in 1 column
or 1 row but using it to search more then 1 column or row doesn't work.
Basically what I want to happen is to have Match return the column #
in which the value resides so that I can use it in the Index function
to return the Column heading.

The Table has 49 rows and 49 cells. Anyone have any ideas or thoughts.
Here is what I have so far.

MATCH(C5,Table,0)

I keep getting a return of #NA

Thanks,
Jeff