In the attached workbook, the worksheet has the data I am trying to work with.
In Row J34:AD34 there is either one of the following values: 30%, 60%, 90% The rest of the cells contain #N/A
I need to figure out how to search through the cells, find the corresponding value; 30%, 60%, or 90% and return the date value from 17 rows above. (J18:AD18)
4,0),"") will give me the position in the range, but I can not figure out how to relate that to the actual column number to offset from.