VLOOKUP with DATE TIME cell

[DarrenK]

Can someone help me understand why this VLOOKUP formula isn't working?

I have worksheet 1 with raw data and there is a column of cells custom formatted m/d/yyyy h:mm:ss AM/PM.

I have worksheet 2 (same file) that is using VLOOKUP to reference a unique segment id located on the same line of each date/time in worksheet 1 and therefore should be displaying the date and time of the respective row in worksheet 2.

My issue is ALL dates/times that are being pulled into worksheet 2 from the raw data are all equal to the very last row's date/time. (8/4/2017 10:55:37 AM happens to be the last displayed date/time in the raw data) After I try to run VLOOKUP on every row, all pulled data is exactly the same (8/4/2017 10:55:37 AM). I've found issues where date/time formatting is off and won't work with VLOOKUP but as I don't have a lookup value of the date/time but merely want to display the date/time as it appears in a specific cell, can anyone please explain why it's not working?

Thank you in advance

 

[JoeMo]

Possibly, you have omitted an argument in your formula. If you post the formula and some sample data, that possibility can be ascertained.