=HLOOKUP doesnt work for this table

Hi,
Of course it doesn't work! You try to find a values 1, 2, 3 in a list of dates that are numbers greater than 44000.
Insert in L21 the exact date you trying to find.
In the best case try to attach the file whose photo you posted (see the yellow banner at the top of the forum page)

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...d-n-a.1218026/)

Formula:

Please Login or Register  to view this content.

Shall do the job. (for production line 1)

Please note that at this forum (as opposite to the other with crossposts - next is on https://techcommunity.microsoft.com/...-a/m-p/3641840 ) you can attach excel file. Then if answer also contains the file, you will see the formula in your version of excel (function names, separators, ...)


And saying that something is not working is not enough - say how you'd expect it works (describe desired result).