Hi,
I'm hoping someone can assist with a lookup issue I am having, attached is some example data.
I need to lookup the time spent in specific reasons for specific people. I would usually use Offset, Index, Match however the position of the reason I need to look up varies depending on the different reasons used by each person each day.
Is there a way around this?
Thanks in advance
I'm hoping someone can assist with a lookup issue I am having, attached is some example data.
I need to lookup the time spent in specific reasons for specific people. I would usually use Offset, Index, Match however the position of the reason I need to look up varies depending on the different reasons used by each person each day.
Is there a way around this?
Thanks in advance