Looping Question

[light]

Have this code:

Please Login or Register  to view this content.

This gets the value from column B sheet2 to matching name in column A Sheet 1 and puts it in column B sheet 1. But the first and third values in column B sheet1 are not found for some reason. It can go all the way down and everything else is found. This is how it works:

Col A Sheet 1

Item 1
Item 2
Item 3
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10

Col A & B Sheet 2

Item 1 1.99
Item 2 2.99
Item 3 3.99
Item 4 4.99
Item 5 5.99
Item 6 6.99
Item 7 7.99
Item 8 8.99
Item 9 9.99
Item 10 10.99

After running code looks like this Columns A,B,C Sheet 1

Item 1 NotFound
Item 2 2.99 Found
Item 3 NotFound
Item 4 4.99 Found
Item 5 5.99 Found
Item 6 6.99 Found
Item 7 7.99 Found
Item 8 8.99 Found
Item 9 9.99 Found
Item 10 10.99 Found

[FDibbins]

Thanks for the changes

[kev_]

oops - deleted as instructed!

[kev_]

Your code is not the problem
- the contents of your cells do not match
- a trailing space perhaps

Test with this formula (where A1 is each of the 4 cells in turn)
=LEN(A1)

The length of "Item 1" and "Item 3" is 6
2 of the 4 cells will return a different value

[light]

Kev

Thanks. Seems to work today. You may have been right about not having an exact match.