I'm new in this forum - good day to everyone.
I need your help in a problem that I could not figure myself why it is not working.
I have 2 tabs involved in my problem:
CLEANUP = this tab contains a table with header (A,B columns) which is filtered by A column criterias, B column is empty
ACTION = this tab contains a table with header (A:H)
In CLEANUP tab, I want a VLOOKUP function in column B. Here is my code:
Dim lLastRow2 As Long
lLastRow2 = .Cells(.Rows.Count, "A").End(xlUp).Row
With .Range("B2:B" & lLastRow2)
.FormulaR1C1 = "=VLOOKUP(RC[-1], ACTION!R2C1:R200C5,5,FALSE)"
.Value = .Value
The problem is that for the last few results are incorrect (there are no such records in ACTION tab table as I look up, however, it lists the first ACTION entry row result).
I tried with 0 instead of FALSE aswell, without success.
Can you please help me what can be the reason the exact match is not working properly?
Thank you in advance!