Hello everybody.
I have an specific date and another "range of dates" where I'm trying to find data and put it in the other sheet.
I used VLOOKUP but didn't work.
I'll share an example and how would see the data.
Thank you for help. 
Searching on multiples dates.
-
-
-
You have two different date formats. One is US format and the other is European. You need to be consistent for vlookup to function properly.
-
The Format shouldn't make any difference.Excel stores dates as number, formatting is just that - what you see.
Quote
Excel stores dates and times as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day: ddddd. tttttt . This is called a serial date, or serial date-time. The integer portion of the number, ddddd, represents the number of days since 1900-Jan-0The dates in Hoja2 are not stored as dates - have a look they have an apostrophe in front which makes Excel read numbers as strings. Quicly convert them to dates using TextToColumns from the Data Tab of the ribbon. then try your formula again.
-
Here's the VLOOKUP formula working
-
-
-
I did say that and suggested using Text To Columns to convert to proper dates
-
It's working!!
Thanks a lot guys.
Cheers.
-
Pleased to help
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!