I have a spreadsheet searching for specific text in various cells.
First I need to identify which row the specific text is in (using the =match function). Which I have done no problem.
Next I need to extract just the required text. I am doing this using a series of =MID(LEFT( .. FIND to find text between two specified strings on a specified row.
However my issue is when I do not want to specify (or hard code) the cell reference in the formula and I want the formula to somehow 'lookup' the required cell reference from the results of the separate =MATCH formula mentioned earlier.
Attached is a spreadsheet to better explain.
Any help much appreciated