Hi,

I need some help solve this problem.
Supose I have the array as in the file in attach.

I want to:
1) find the first value in the range A9:L9 (result: "1")
2) retrieve header for that column (result: "i")
3) find the next value in the range A9:L9 (result: "8")
2) retrieve header for that column (result: "l")

Best Regards,
Elio


+-------------------------------------------------------------------+
|Filename: FirstValueInaRow.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=4240 |
+-------------------------------------------------------------------+

--
efernandes67
------------------------------------------------------------------------
efernandes67's Profile: http://www.excelforum.com/member.php...o&userid=17916
View this thread: http://www.excelforum.com/showthread...hreadid=502585