Hi,

You can not do this with a spreadsheet formula because you it would be a
circular reference. Your only alternative would be to use a VBA macro.
However, we would need to know how Pathma fits into the picture. How do we
know who is the backup for who?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Fareez" wrote:

Dear Friends
I want to prepare leve chart . plese help me to solve it
Eg
A B C D
1 Fareez H N
2 Pathma
3 Rusdhi N H
I have entered staff name in cloumn and date in row. in this list Fareez is
back up for Rusthi. if rusthi takes leave , Fareez can not be allowed for
taking leave.

I am using " H" for annual Leave "N" means not allowed to take leave. if I
enter H for rusthi then autoimaticaly N sld come for Fareez and vice versa.
I used "If "function but not much support. please note that if I enter H for
Rusthi and If leave is cancelled later I sld be able to delete H without any
affect to formula that cell contains .
there is no must to use N if we can block that cell also fine

Please help me