Is there a lookup or similar function that I can use in excel to search for an exact match and then retrieve a cell 48 cells right and 1 below? I have attached an image of the automated report that is generated below.

Is there a lookup or similar function that I can use in excel to search for an exact match and then retrieve a cell 48 cells right and 1 below? I have attached an image of the automated report that is generated below.

Closed 8 hours ago.

Good day,

Good day,

Good day,

I have a loosely formatted table that has People going across the top, tasks going down the rows, and a column for start date and column for End Date. The user will input expected hours in the given subtasks and it will rollup into the task itself. I was able to get a sumifs by row divided by the number of months being looked up, but not have the value spread correctly over the relevant months.

I have a loosely formatted table that has People going across the top, tasks going down the rows, and a column for start date and column for End Date. The user will input expected hours in the given subtasks and it will rollup into the task itself. I was able to get a sumifs by row divided by the number of months being looked up, but not have the value spread correctly over the relevant months.

I have a loosely formatted table that has People going across the top, tasks going down the rows, and a column for start date and column for End Date. The user will input expected hours in the given subtasks and it will rollup into the task itself. I was able to get a sumifs by row divided by the number of months being looked up, but not have the value spread correctly over the relevant months.

I am trying to extract the a set of 9 characters that follow the text “VRID”. There are a few variations on the text I am trying to extract.