I am, not certain which function to use for the following problem:

I have an array 45 columns long by 26 rows. This array contains
numerical references, and I want to find the vertical leftmost cell
value and the heading cell value for a given number in the grid
(array). There will be only one iteration of a value in a given
column, but will be multiple iteration in a given row.

Excel 2000

Any help would be much appreciated.

John Baker