Post the formula you tried.

Copy it from the formula bar (from excel) and paste it into your response.



bagus wrote:

HI Dave,

thanks for the quick reply. I have tried to match your instructions and
have managed only to get #NAME? as a result.

Anything that I am doing wrong?

Product codes contain both letters and numbers, and in addition symbols
(rare). Do I have to format the column to a specific format?

regards,

/bagus

Dave Peterson Wrote:
=if(iserror(vlookup(b1,sheet2!a:b,2,false)),"",vlo okup(b1,sheet2!a:b,2,false))

Is one way.

bagus wrote:

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

--

Dave Peterson

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

--

Dave Peterson