Formula in cell B6 in "AP" sheet looks at # value in A6 in "AP" sheet. This value is looked for in column I in "Data" sheet. Once value is found in "Data" sheet column I it must look at the cell left of it (same row) in column H and return the text that will be within the same row in column J in "Data" sheet only if the value "3" is true in column H. If cell value is not "3" in column H, it skips that row in the "Data" sheet and keeps looking down column I within the "Data" sheet. I am thinking it would best to use VLOOKUP and IF / ONLY IF formulas to accomplish this. I have excel files I can send to help explain if needed.
Solved by Z. E. in 18 mins