Using the Match Function?
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
|