Comparing rows on one sheet to list on other

  • Thread starter Thread starter stevem
  • Start date Start date
S

stevem

Yes, that is exactly what I wanted, and it's picking up the cell value
from H like it should, but the result of the Match always returns that
"Error 2042" so it's not seen as a match.. I found this out by putting
MsgBox CStr(res) right at the end of the for loop, so I could see what
the value of res was every part of the loop. I know that cell H1 will
not be a match, and that H2 will be a match.. and on both I get that
error code popping up in my MsgBox.
 
What two values are you comparing (that you know match)?

is it possible that one is a string ('123 and one is a value 123).

How about Leading/trailing/embedded spaces.

If you pick out those cells (say A2 and H9), if you put:

=Elements!h9=servers!a2

What do you get (true/false)?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing rows on one sheet to list on other 1
My Never ending ARRAY code problems 18
Triming trailing spaces before using Match on columns of numbers withleading zeroes formatted as tex 1
Resize to last entry in row and copy to sheet 1 3
Write to intersect of a row and column 7
Looping through sheets and comparing data 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
compare all matches 3

Back
Top