I have an excel sheet with a list of dates and I want to find the matching row for a date in another sheet.
The list of dates are formatted as dates, not as text...
Example:
In sheet1 I have a text value in cell A2 like "2022-08-29 09.58.51"
A formula in cell B1 [=VLOOKUP(DATEVALUE(LEFT($A2;10));'sheet2'!$A:$D;2;FALSE)] gives a nice value of 16.9
But when I want to get the row number of the list and put a formula in cell C1 [=MATCH(DATEVALUE(LEFT($A2;10));'sheet2'!$A:$D;0)] I get an error #NA
I've tried a lot of things but I can't figure out what goes wrong...
Can somebody help me in the right direction ?
If the VLOOKUP gives a match then the MATCH function should also do the trick or not.
Thanks in advance
The list of dates are formatted as dates, not as text...
Example:
In sheet1 I have a text value in cell A2 like "2022-08-29 09.58.51"
A formula in cell B1 [=VLOOKUP(DATEVALUE(LEFT($A2;10));'sheet2'!$A:$D;2;FALSE)] gives a nice value of 16.9
But when I want to get the row number of the list and put a formula in cell C1 [=MATCH(DATEVALUE(LEFT($A2;10));'sheet2'!$A:$D;0)] I get an error #NA
I've tried a lot of things but I can't figure out what goes wrong...
Can somebody help me in the right direction ?
If the VLOOKUP gives a match then the MATCH function should also do the trick or not.
Thanks in advance