VLOOKUP returns the value of a cell pursuant to the inputs within the function. Is there an equivalent function that returns a cell address instead of the value within?
I am trying to design a flexible way to find the standard deviation of a range with the easy ability to change the beginning and end point for comparisons. I had hoped this formula would have done the trick:
=STDEV(OFFSET(VLOOKUP (t5,full,3),( VLOOKUP (t4,full,2)- VLOOKUP (t5,full,2)),0, VLOOKUP (t5,full,3))
However, it does not work, and I now realize it is because the first VLOOKUP (just after the OFFSET function) is returning the value within the cell, and I was looking to insert the cell address.
Is there a different function that will accomplish what I am trying to do?
Bookmarks