How can I make a function that looks for a value on a sheet, on unknown
column or row, and returns row and column position where it found it. I
presume it has to be done using MATCH in an array formula that searches
entire columns from 1 to 255 and ISNA to ignore the unmatched columns,
and ADDRESS to inform the cell found... I've been trying unsuscesfully
to assemble it and make it work...

Thanks. Paul.


--
Paul134
------------------------------------------------------------------------
Paul134's Profile: http://www.excelforum.com/member.php...o&userid=31735
View this thread: http://www.excelforum.com/showthread...hreadid=516275