Search code examples
excelcell

referencing a cell in a cell id

I have an excel sheet where cell B30 returns a value of 26 using the Match function. This means that in cell M26 there is a value I want to retrieve. How do I retrieve the value of M26 without writing =M26 as the value 26 will change.

Solution 
  • =INDEX(M:M,B30)

    This will work as long as you know the cell you want will be in column M.