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 data isn’t organized into a table. Getting confused by the LOOKUP, MATCH formulas.
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 data isn’t organized into a table. Getting confused by the LOOKUP, MATCH formulas. Read More
