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
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
