...........A..........B..........C
1.......H1........H2........H3
2.......10.........12.........12
3.......12.........14.........13
4.......16.........15.........11

So, if your lookup value is 12 you want the header that corresponds to 12
found in cell A3?

If that's what you want try this array formula** :

=IF(COUNTIF(A2:C4,12),INDEX(A1:C1,MIN(IF(A2:C4=12, COLUMN(A2:C4)-MIN(COLUMN(A2:C4))+1))),"")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"JHB" wrote in message
...
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