Hi,

Can anyone help me?

I have some text in cell A1 and i wish it to search in column A on 5
other worksheets for that reference. If it then finds a match on one of
the sheets i want it to tell me on sheet1 in B1 that its in worksheet 4
for example

ie

sheet1 A1 = Toy Car

sheet4 A335 = Toy Car

sheet1 B1 = Sheet4

Can this be done??

Any help appreciated

Regards

Craig


--
BSLAUTOMATION
------------------------------------------------------------------------
BSLAUTOMATION's Profile: http://www.excelforum.com/member.php...fo&userid=7611
View this thread: http://www.excelforum.com/showthread...hreadid=400755