Have a look in vba help index for FINDNEXT. There is an example.

--
Don Guillett
SalesAid Software

"bagus" wrote in
message ...

I have two worksheets :

Sheet 1:

A1 Country
B1 Product Code
C1 Product (empty cell - need to insert result of the formula in it)

Sheet 2:

A1-A1000 Product Code
B1-B1000 Product Name

I need to compare B1 (Sheet 1) with the range in A1-A1000 (Sheet 2) and
if they match than to retrieve the value from B cell (Sheet 2) and
insert it into C cell (sheet 1).

Can anyone help me. I know that it is trivial, but i have not made it
work till now.

/bagus


--
bagus
------------------------------------------------------------------------
bagus's Profile:
http://www.excelforum.com/member.php...o&userid=35323
View this thread: http://www.excelforum.com/showthread...hreadid=550980