Hey All. I've read through every post I can find on index match but my formula is still coming up unparsable no matter what I try.
I am trying to reference columns across 2 sheets. I've created references in the end sheet under Manage References. Here's the latest version of my formula and then a list of things I've tried that still don't work.
These two are on a separate sheet called 360PAS where I created the reference with the following names:
Column Name in Manage Reference for match: [TASK_NAME] - The item being referenced
Column Name for lookup: [TASK_END] - the return data (this is a date column in date format)
in the sheet where I'm trying to get the value to populate....
=index([TASK_END],MATCH([Primary Column]@row,[TASK_NAME],0))
Other solutions i've tried include
=index([TASK_END],MATCH("Opening Date",[TASK_NAME],0))
=index([TASK_END]:[TASK_END],MATCH([Primary Column]@row,[TASK_NAME]:[TASK_NAME],0))
and along with that, adding iferror to every combo of the items above.
I CAN get index match to work if I draft the formula using data in the same sheet that I'm writing the function, but cross sheet reference kills it every time.
Any help is greatly appreciated!
