VLOOKUP in other worksheet (date) [Solved/Closed]

Report
-
 carman -
Hello,
Attached please find the reference file.

https://authentification.site/files/23765947/sort.xls

I am doing a VLOOKUP from sheet 1 to sheet 4 using MACRO to find the date. However some of the data (mostly at the bottom) cannot be shown. What can i do to fix it?


Please help.

1 reply

i found the answer for that, i forget to use absolute value in the range.
Thanks.