I want to run a search for value "Item Text:" and return the value 3 cells below it
Say Item Text: appears in cell A46, I want to return the text in cell A49 into a table
I need to be able to drag the formula down to account for all instances of Item Text in the whole document.
I have other values that are directly across from the search value and I am using this formula: =INDEX(Raw!B:B, SMALL(IF($N$1=Raw!A:A, ROW(Raw!A1:A20000)-MIN(ROW(Raw!A1:A20000))+1, ""), ROW(Raw!A1)))
but I can't figure out how to get it to return the value 3 cells below instead of to the right
Solved by I. H. in 29 mins