Changing a employees Status Date!

[Steve]

Hope someone out there can help!
I have created a six page spreadsheet, which in turn
prints out two separate reports.
On one page, if a cell on page 1 contains a Y, then the
cell on page 6 should remain blank. If the cell on page 1
is blank, then the cell on page 6 should contain the date
that is listed next to the cell on page 1.
Basically its to change an employees status date.
Everything I try gives me error codes.

Thanks

Steve

 

[kathy]

Tyr this but make sure the cell in sheet 6 is in date
format.
=IF(Sheet1!A1="",Sheet1!B1,Sheet6!$A1="")

 

[Debra Dalgleish]

How are you matching the employee data from sheet1 to sheet6? If the
sheets are set up identically, and you're just referring to the same row
on sheet1, you could use a formula like:

=IF(Sheet1!A2="Y","",Sheet1!B2)

If you're using a VLookup to find the data:


=IF(VLOOKUP(A2,Sheet1!$A$2:$B$25,2,0)="Y","",VLOOKUP(A2,Sheet1!$A$2:$C$25,3,0))