VLOOKUP in other worksheet (date)

Solved/Closed

carman - Aug 12, 2010 at 04:18 AM
carman - Aug 13, 2010 at 12:58 AM

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.

VLOOKUP in other worksheet (date)
Iserror function in excel with vlookup - Guide
Vba add worksheet - Guide
Transfer data from one excel worksheet to another automatically vlookup - Guide
Copy worksheet to another workbook vba - Guide
Excel split worksheet - Guide

1 response

Answer 1 / 1

carman
Aug 13, 2010 at 12:58 AM

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

Similar discussions

How to invoke VLookUp function in Excel VBA.

How to specify macro for current active sheet

Copy worksheet from one workbook to another workbook in MS Office Excel

Removing "FALSE" from an IF statement with a VLOOKUP

Consolidate data from multiple sheets to one sheet.

Similar discussions

Subscribe To Our Newsletter!