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

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

=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

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

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

Here is the formula I used:

=IF(ISERROR((VLOOKUP(Sheet1!C1;Sheet2!A:E;2;FALSE) );"";VLOOKUP(Sheet1!C1;Sheet2!A:E;2;FALSE)))

Do you see the mistake?

/bagus

Dave Peterson Wrote:[color=blue]
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[color=green]
(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))[color=green]

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

Watch your parentheses:

=IF(ISERROR(VLOOKUP(Sheet1!C1;Sheet2!A:E;2;FALSE)) ;"";
VLOOKUP(Sheet1!C1;Sheet2!A:E;2;FALSE))

I don't see a problem that would cause a #name? error, though. Are you using an
English version of excel?

If not, you'll have to translate =iserror() and =vlookup() to your language.

If you post the language you use, maybe someone can help.

bagus wrote:[color=blue]

Here is the formula I used:

=IF(ISERROR((VLOOKUP(Sheet1!C1;Sheet2!A:E;2;FALSE) );"";VLOOKUP(Sheet1!C1;Sheet2!A:E;2;FALSE)))

Do you see the mistake?

/bagus

Dave Peterson Wrote:[color=green]
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[color=darkred]
(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