Forum Discussion
Solved
Returning a cell's value based on the location of another cell.
I want to search an entire worksheet for a value and once that value is identified, I want to pull the cell's value that exists five cells below it. vlook, xlook, and hlookups don't work because the ...
MDLeach What version of Excel are you using? If you have Excel for MS365 or Excel for the web, you could try the following:
=TAKE(TOCOL(IFS(range = lookup_value, OFFSET(range, 5, 0)), 2), 1)For example:
=TAKE(TOCOL(IFS(A4:J10000 = B1, OFFSET(A4:J10000, 5, 0)), 2), 1)Sample Results
MDLeach What version of Excel are you using? If you have Excel for MS365 or Excel for the web, you could try the following:
=TAKE(TOCOL(IFS(range = lookup_value, OFFSET(range, 5, 0)), 2), 1)
For example:
=TAKE(TOCOL(IFS(A4:J10000 = B1, OFFSET(A4:J10000, 5, 0)), 2), 1)
Sample Results