Thread: Skipping Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CellSkipper CellSkipper is offline
external usenet poster
 
Posts: 2
Default Skipping Cells

I am using two sheets of information. In the second sheet I want to take a
cell from Sheet one and then skip down cells in sheet one to get the next
cell. Is there any way to create a formula that will do that?

Sheet
A30 235-364
A60 211-354

I want to create formula that will allow me to get these two cells without
having go back to Sheet 1 every single time