Hi @RiKi

Apologies for the following questions, but I'm a little confused by what you're trying to achieve.

I think you're trying to achieve the following:

=INDEX([Hidden Cols -->]$2:[Duration]$3, 2, MATCH([Assigned To]$2, [Hidden Cols -->]$2:[Duration]$2, 0))

The Syntax is INDEX(range, row_index, [column_index])

The range is between the column titles [Hidden Cols -->] row 2 and [Duration] row 3

You already know that you want to return the value (date) in second row of that range.

We now use Match to identify which column number to return.

The MATCH syntax is (search_value, range, [search_type])

The search_value is in the cell [Assigned To]$2

The range is between the column titles [Hidden Cols -->] row 2 and [Duration] row 2

You want the search type to be an exact match, hence we use the number '0'

When using AI to help with creating formulas, you can use the syntax to help.

For instance, you may use wording like:

Using INDEX and MATCH functions, where the range is from [Hidden Cols -->]$2 to [Duration]$3, the row_index is row 2 and the column_index uses the Match function to look at the value in [Assigned To]$2 cell, and match the exact value in the range between [Hidden Cols -->]$2 to [Duration]$2.

Hi @RiKi

Please redo your first screenshot in your first post and include the row numbers please.

It sounds like we simply need to change the INDEX row_index from 2 to 3, like this:

=INDEX([Hidden Cols -->]$2:[Duration]$3, 3, MATCH([Assigned To]$2, [Hidden Cols -->]$2:[Duration]$2, 0))

try this:

=INDEX([Hidden Cols -->]$2:[Duration]$4, 4, MATCH([Assigned To]$2, [Hidden Cols -->]$2:[Duration]$2, 0))

Hi @RiKi

The author is actually on row 3, with dates on row 4.