How to create a formula that substitutes 1 piece of text for anoth

E

Ed Anton

I'm referencing cells on a different worksheet with information in, but where
it is says 'Yes' on Sheet 1 I need it to say '1' on sheet 2. Likewise, where
it says 'No' on sheet 1, I need it to say '2' on sheet 2. Can anyone tell me
how this could be achieved?

Thanks.
 
D

DevalilaJohn

Are you working in Access or Excel? For Excel, you'll get better responses
from that group.
 
Top