I want to find the information in column 'A' after finding the
referenced cell i asked for.

My search is for MS35206-230 but I want Column A returned

Example

Col A Col B Col C
.05 Red MS35206-230


--
MrSales
------------------------------------------------------------------------
MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572
View this thread: http://www.excelforum.com/showthread...hreadid=523698