I have to find a value by date in Google Sheets between multiple tabs. I boiled it down and boiled it down until I made the most simple example I could find, and yet it still didn't work. Date notations are the same, the dates are a match, but still it reads like a number and returns an n/a. Made an example sheet, feel free to mess around

Example sheet

CodePudding user response：

try like this:

=IFNA(VLOOKUP(A1; {D:D\ C:C}; 2; 0))

CodePudding user response：

Or this

=index(C:C;MATCH(A6;D:D;0))