INDEX and MATCH help

GHobbs

Hello,

I am building a dashboard to pull information off multiple sheets, and have created a separate "config" sheet to use formulas and organize the information to make widgets easier.

I am looking to pull info from a date column in a project plan, based on a unique task name.

I have a column in the config sheet that matches these unique values to reference within the same row, but have also just tried to use the text to look for in quotation marks.

Originally I tried this:

=INDEX({StartDateColumnref}, MATCH(ConfigSheetTask@row, {TaskNameColumnref}))

which is returning just a blank cell. Took out the ConfigSheetTask@row reference within the sheet and tried this:

=INDEX({StartDateColumnref}, MATCH("Unique Task 1", {TaskNameColumnref}))

Still nothing in the cell! Looked around the forum and found I might have been missing a 0 at the end. So I tried these:

=INDEX({StartDateColumnref}, MATCH(ConfigSheetTask@row, {TaskNameColumn},0))

=INDEX({StartDateColumnref}, MATCH("Unique Task 1", {TaskNameColumnref},0))

Which returns #INVALID COLMN VALUE , but I know that value is within that column...

All I'm trying to do is: on a separate sheet, find the row in Task Name column that has my unique value, and return the value from the Start Date column in the same row. Please let me know if you have advice!

David Joyeuse

Hi @GHobbs

Try this:

=INDEX({StartDateColumnref}, MATCH([Task Name]@row, {TaskNameColumn},0))

#INVALID COLUMN VALUE probably means you're trying to return a Date to a non Date column.

Hope it helped!

David Joyeuse

Hi @GHobbs

Try this:

=INDEX({StartDateColumnref}, MATCH([Task Name]@row, {TaskNameColumn},0))

#INVALID COLUMN VALUE probably means you're trying to return a Date to a non Date column.

Hope it helped!

GHobbs

@David Joyeuse That did it, totally forgot about changing the column properties to a date column which solved things.

Cheers!