Vlookup Date into another Date field - #DATE EXPECTED Error



I am using a VLOOKUP to pull a date into a sheet from another sheet. Both columns (date source / range, and destination column) are Date column types, but the destination sheet is returning the # DATE EXPECTED error.

I thought if you were pulling a date from a date column, into another date column, the return value would be a date.

Here is my formula:

=VLOOKUP([Email]@row, {Date Range}, 6, 0)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!