referring date to cell on different sheet

[haroldstevens]

i'll try to make this as simple as possible...


i have 3 worksheets: ledger, deposit1 and deposit2

the ledger worksheet has 60 cells for date deposited by each tenant

deposit1 worksheet has one cell for the date of that deposit and 60 cells for dollar amounts
deposit2 worksheet has one cell for the date of that deposit and 60 cells for dollar amounts

i would like the ledger worksheet to input the date from deposit1 OR deposit2 if there is an entry made on either sheet in one of the 60 dollar amounts

in other words, i will have:
26 entries for dollar amount on deposit1 worksheet
and
34 entries for dollar amount on deposit1 worsheet

so i want any cell with a deposit entered on either worksheet to reflect the date of that worksheet into the ledger cells for the related tenant... if the cell is empty, no date will be recorded

does this make any sense?

[haroldstevens]

i figured it out...
=IF('Deposit Feb 2'!D3>1,'Deposit Feb 2'!H1,IF('Depsoit Feb 3'!D3>1,'Depsoit Feb 3'!H1,""))

thanks for being here for the support... i just get worried a little faster than i should