Function Help
 

Hi,

Ive had some really good help so far thanks to this site and
hopefully someone can piont me in direction for this one.

I have 8 worksheets and Im trying to get a specific reference from A1.

The specific reference is listed on the other 7 pages in column A

I want it to tell me the reference it found, if its possibly

Example
sheet1
A1 = abc toy car 789DIN19
sheet2 = Toy Cars
A67= 789DIN1977

This is the closest reference on all of my worksheets

i want C1 to = 789DIN1977


Any help?


--
atxcomputers
------------------------------------------------------------------------
atxcomputers's Profile: http://www.excelforum.com/member.php...o&userid=26852
View this thread: http://www.excelforum.com/showthread...hreadid=469013