View Single Post
  #1   Report Post  
szwanger szwanger is offline
Junior Member
 
Posts: 1
Default Converting a number into a cell reference

I want to pull a number from a particular cell and then use that to create a cell reference for the cell in row Q and the column of that number, and look up that cell in a different sheet.

For example, let's say Sheet 1, cell K1 contains the number 72. I want =formula to return the contents of Sheet 2, cell Q72.

So how do I write this formula? :-)