Vlookup or Index in a date column

KarineMul22_TPg

I have read all the comments relating to the above, but nothing works for me. So I had to Link a cell, which means that if a row or column is added, I will have to amend the link.

I just wanted my Start date in a Gantt at Task@row to be able to look for this Task@row in another Gantt sheet and come back with the corresponding date. The function itself seems not to appear in the initial Date Column, when I "force" it, then there is no option to link an other sheet reference.

Please if you know for sure, could you let me know (how or impossible :))

Many thanks

Mike TV

@KarineMul22_TPg

Use an absolute reference so if a row is moved it will still know where to look.

https://help.smartsheet.com/articles/2476816-create-cell-column-reference-formula

It's explained on the 3rd row of the chart on the link above.

Genevieve P.

Hi @KarineMul22_TPg

As long as the Task@row is unique across both sheets, you can use an INDEX(MATCH formula combination for this!

=INDEX({Column with Date to return}, MATCH(Task@row, {Column with Task in other sheet}, 0))

However keep in mind that if you're using Dependencies in your sheet you won't be able to put a formula in a Start or Finish date column (see: Areas where formula use is restricted)

Cheers,

Genevieve