I'm trying to return a cell address from a vlookup function so that I can use offset to calculate the average of the cells following the first value that it finds with the vlookup.
In other words, I am looking for the first 2 in a column and want to sum the values4 columns over and 40 rows down. I know I can use offset, i just need to get the first cell address by formula.
This is only for formula within excel. Thanks for the help!