V-lookup not giving correct results through VBA

[ruchikasharma9727]

Hi,

In my attached file there are two months of data: Previous Month and Current Month.
In current Report sheet- I want COl. O be updated with a lookup value from Col. H in Previous report sheet. Any cell that comes as blank should be updated as Added.
When I run the below mentioned code, my results for Small Switches are coming as 119 whereas it should be 104. Please assist. Below is my code and attached is the dummy file. Please assist at the earliest. Thank you.

Please Login or Register  to view this content.

Please note- I tried changing the lastrow3 and it worked but then in this case, it takes time to run. Any help?

I changed the last row 3 as:

lastRow3 = sht4.range("a1").End(xlDown).Row

[Andy Pope]

no attachment, in order to check you code and the value of the variables

[ruchikasharma9727]

Just added it.

[Andy Pope]

First I assume i need to add 2 worksheets in order for the code to even run?

Where is 109? You need to explain exactly where the information is not as expected, what you think it should be and why?

[Andy Pope]

I did the formula manually and I can see there are 104 records that are both #N/A and "Small Switch".

I do not get 109 after running your code, I get 104 as expected