View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default select cell based on a number in another cell

This is what I want to do


I have a cell A1 with the number 40
In another cell I want to use the number 40 to select a cell, something
like: =B40+234
Where 40 in B40 is the number typed in A1.

how do i do this please?