I'm trying to capture the dates

[Solazie]

Hi,

I'm trying to capture my dates, I'm using Hlookup but it always shows n/a. And my grid is kinda like this

Item Number	Item Description	ETA	01/01/17	01/05/18
21454	ABC1		2,115	1,222
21455	ABC2		0	3,008

<tbody>
</tbody>

I want to capture the right date from the right quantities from the item number.

Please guide me with this.

Thank you

 

[Oaktree]

Welcome to the board.

Are the "01/01/17" and "01/05/18" values in the header text values or Excel dates? i.e. if you format the cell with 01/01/17 as a number, does it show 42736? Or does it still show the text "01/01/07"?

If it's text, try =HLOOKUP("01/01/2017",A1:E3,2,0)

If it's an Excel date/number, add a +0 to try =HLOOKUP("01/01/2017"+0,A1:E3,2,0)