If Then Formulas
Hi, I am using Excel 2000. I have several sheets in a workbook and am trying
to create a formula so that when specific words are in a cell in one sheet,
they appear (but as a differnt word) on another in the appropriate cell.
EG: Sheet 3 - ARL, CL, SL, LSL, etc all to appear on Sheet 1 as LEAVE?
Sheet 1 is an overview of the other sheets in the workbook an only needs
high level detail.
Thanks for any advise. Kat
|