Can you INDEX and MATCH a date

Warren Labuschagne

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

Kelly Moore

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?

Kelly

Kelly Moore

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?

Kelly

Warren Labuschagne

https://community.smartsheet.com/discussion/comment/341284#Comment_341284

@Kelly Moore thank you very much, it's working!