Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xlFunctions03.html

Take a look at example 3. She uses index() to get the first row/first column of
a table.

" 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

--

Dave Peterson