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)
Transfer data from one excel worksheet to another automatically - Guide
How do you add a username or author to a worksheet - Guide
Automatically run a macro when opening a worksheet - Guide
Vlookup subtraction formula ✓ - Office Software Forum
Excel vba copy worksheet to another workbook without opening ✓ - Excel Forum

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 specify macro for current active sheet

Lookup partial text contained in cell range

Comparing columns and returning value

Match partial text string in one sheet to another text string in another sheet

Enter current time in a cell by clicking it

Similar discussions

Subscribe To Our Newsletter!