DougDodge
asked on
Perform a search in an array, return an offset value
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)
=IFERROR(MATCH(0.9,J34:AD3 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.
Any ideas?
Problem.xlsx
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)
=IFERROR(MATCH(0.9,J34:AD3
Any ideas?
Problem.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER