Too bad a lot of OPs aren't as gracious as we are.<g
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I was trying to come up with an array formula (not my strong suit at all),
thinking it would be more concise - thanks for putting that up and letting
me
see it. Nice and tidy.

"RagDyer" wrote:

Try this *array* formula:

Enter number to find in E1, then:

=INDEX(A1:D1,MAX(IF(A2:D3=E1,COLUMN(A:D))))

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead
of
the regular <Enter, which will *automatically* enclose the formula in
curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lisa" wrote in message
...
How do i do a reverse lookup to show the heading in the first row.
Example:
Say I want to now which month the value 29 show up in the below table?
All
I
want the answer is "MAR" or value of 32 is in "Apr". Many thanks



1 A B C D
2 Jan Feb Mar Apr
3 25 27 29 31
4 26 28 30 32