Having Trouble With VLookup

[iccreamann]

Hello All,

I am having trouble with a vlookup. I'm not sure what I am doing wrong, but it keeps displaying the last row in the table. I attached the document and the formula I'm having trouble with is on the "data" sheet. Any help would be appreciated.

Thank you
M

[FlameRetired]

Perhaps

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[iccreamann]

That wouldn't work. I'm looking at H3 (which is a date) and I want it to look in the table and find that date and then Project the ID in I3.

[FlameRetired]

If you are attempting to use the date as a lookup value perhaps this is what you actually want. In I2

Please Login or Register  to view this content.

and in J2

Please Login or Register  to view this content.

	G	H	I	J
1	Top 4 Oldest
2
3	1	01/12/16	4	C-Clips to Power Steering Line NC
4	2	02/22/16	17	TOC lines not stowed
5	3	02/25/16	7	Body bolts missing
6	4	03/15/16	8	Brake line x-tree not inserted to the frame
7

[iccreamann]

You are my hero! Thank you that was the answer!

[FlameRetired]

You are welcome. Glad to help.