Hi, I am new to posting to this forum so thanks in advance!
I am trying to use INDEX MATCH to find a value in a table based on a date. The table that I am search is from an external system and the dates all came across as text (left aligned in the cell). If I hit enter on the date cell, the correct value will return. The issue is that I am pulling 3 years worth of data and I dont want to hit enter on every date. Is there a way to use datevalue on a range or another method to use?
C19 is my date
$J$2:$CD$2 is my range of "dates" stored as text.
=(INDEX($J$5:$ES$16,MATCH($C22,$A$5:$A$14,0),MATCH($C$19,$J$2:$CD$2,0)))
Thanks!