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 |
Maybe something like this on Sheet 1 and copied down............
=IF(OR(Sheet3!A1="ARL",Sheet3!A1="CL",Sheet3!A1="S L",Sheet3!A1="LSL"),"LEAVE ","") Vaya con Dios, Chuck, CABGx3 "Kathy-Anne" wrote in message ... 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 |
Hi Chuck, thanks for your response - took me a couple of go's to get it right
but (my error!). thanks very much - works a treat. Have a great weekend, the much less stressed Kat from Australia "CLR" wrote: Maybe something like this on Sheet 1 and copied down............ =IF(OR(Sheet3!A1="ARL",Sheet3!A1="CL",Sheet3!A1="S L",Sheet3!A1="LSL"),"LEAVE ","") Vaya con Dios, Chuck, CABGx3 "Kathy-Anne" wrote in message ... 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 |
You're welcome............thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "Kathy-Anne" wrote in message ... Hi Chuck, thanks for your response - took me a couple of go's to get it right but (my error!). thanks very much - works a treat. Have a great weekend, the much less stressed Kat from Australia "CLR" wrote: Maybe something like this on Sheet 1 and copied down............ =IF(OR(Sheet3!A1="ARL",Sheet3!A1="CL",Sheet3!A1="S L",Sheet3!A1="LSL"),"LEAVE ","") Vaya con Dios, Chuck, CABGx3 "Kathy-Anne" wrote in message ... 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 |
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com