How to Vlookup start with cell less than date

[tuongtu3]

Hello All,
I'm trying to modify the code but it does not work. Please take a look and help me out.

Please Login or Register  to view this content.

Regards,
tt3

[HaHoBe]

Hi, tt3,

what do you want to get out here as you will try to write the formula into a cell which originally holds a date?

Output is to column V here:

Please Login or Register  to view this content.

Ciao,
Holger

[tuongtu3]

Hi Holger,
I modified your code and it work as I need. Thank you very much for your time and help.

Please Login or Register  to view this content.

Regards,
tt3

[tuongtu3]

Hi Holger,
I got a problem with #N/A and how to modify the code:

Please Login or Register  to view this content.

Regards,
tt3

[HaHoBe]

Hi, tt3,

maybe I can do a lot of things but not get what you are after with from what you posted (the range is set up the wrong way as explained earlier on). Maybe you can post a working formula from the worksheet to give me an idea about what to code?

Ciao,
Holger

[tuongtu3]

Hi Holger,
Sorry of short details and made you confuse. Please take a look at sample in attached.

Regards,
tt3

[tuongtu3]

Hi all,
This Formula

Please Login or Register  to view this content.

is same as below code

Please Login or Register  to view this content.

And I would like to need your help to modify the above code to this formula

Please Login or Register  to view this content.

Regards,
tt3

[HaHoBe]

Hi, tt3,

please test this code for the formula:

Please Login or Register  to view this content.

Ciao,
Holger

[tuongtu3]

Hi Holger,
I have modified your code and how to keep the current cell value instead of "1/1/2010".
Let says the current value at cells U20 is "1/1/2012" then if there no data found in sheet2 so the value at cells U20 should be no change at "1/1/2012".

Please Login or Register  to view this content.

Regards,
tt3

[tuongtu3]

Hi,
Is it possible to modify the code per post# 9?

Regards,
tt3

[HaHoBe]

Hi, tt3 ,

from what I know about formulas you can hold the result of a formula only if you turn calculation to manual, use circular references and Iterations (but then why would you need a spreadsheet). I would have go with a helper column for all rows where NA is shown and hold the value there. This might be compared to the search result in the actual sheet and evaluated.

Ciao,
Holger

[tuongtu3]

Hi Holger,
Thank you very much for your help then I would use a helper column.

Regards,
tt3