Can you INDEX and MATCH a date

Warren Labuschagne
Warren Labuschagne ✭✭✭✭
edited 08/25/22 in Formulas and Functions

Can you INDEX and MATCH a date from one sheet and return the value in another sheet? Seems like date format not compatible with INDEX.

The formulas that I have tried are;

=INDEX({1509LV_Schedule Range 1}, Description@row, MATCH({1509LV_Schedule Range 2}))

=INDEX({1509LV_Schedule Range 1}, Description@row, {1509LV_Schedule Range 2})

1509LV_Schedule Range 1 and 1509LV_Schedule Range 2 are both date format columns

I keep getting #INVALID DATA TYPE error


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @Warren Labuschagne

    An Index/Match has the syntax

    =INDEX({range of what you want returned}, MATCH([your match]@row, {Range it can match to},0))

    Your Range #2 shouldn't be a Date column if your Description@row is really a Description field. Range #2 needs to be the same thing Description@row is.

    Does this help you get closer?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!