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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Item Number
[/TD]
[TD]Item Description
[/TD]
[TD]ETA
[/TD]
[TD]01/01/17
[/TD]
[TD]01/05/18
[/TD]
[/TR]
[TR]
[TD]21454
[/TD]
[TD]ABC1
[/TD]
[TD][/TD]
[TD]2,115
[/TD]
[TD]1,222
[/TD]
[/TR]
[TR]
[TD]21455
[/TD]
[TD]ABC2
[/TD]
[TD][/TD]
[TD]0
[/TD]
[TD]3,008
[/TD]
[/TR]
</tbody>[/TABLE]

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)