vlookup problem and count problem

I try the nested for-loop at the past, but data checking is time consuming. So I decide to use vlookup to compare and get the data from another worksheet. I have searched many samples which is only for one workbook. In my code, the variable 'found' get error result, all values are display "NULL".

Please help to solve it...thank you!

Please Login or Register  to view this content.

Try these changes:

Please Login or Register  to view this content.

When you opened the workbook, it became the the focused workbook so you don't have to keep referring to the bookname until you give focus to another workbook, like when you open the next book.

I think you would need to post a sample so we can see the data types in play etc... does the same VLOOKUP entered natively return expected results ? ie

Z4: =VLOOKUP(C4,Sheet2Name,11,0)

Your lookup range is not correct for a VLOOKUP... in a VLOOKUP the criteria must exist in the leftmost column of the range... your range utilises the .UsedRange of the 2nd sheet which is A:K but the ID number you wish to find is in Column E not A -- hence the VLOOKUP returns an error.

I have to go offline now but you could think about using an INDEX/MATCH approach, ie replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.