Formula writing

Occasional Visitor

I am trying to write a formula that states that if something in one cell on one spreadsheet equals a cell in a column on a second spreadsheet,  then the next cell below on the first spreadsheet equals the corresponding cell in the column before on the second spreadsheet.