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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Are you working in Access or Excel? For Excel, you'll get better responses
from that group.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL FORMULA ASSISTANCE 1
Excel If a Cell Contains a Certain Text (From Another Table) 0
Excel A CountIF question... I think 2
Converting text to numerals across spreadsheets 3
Excel VBA 1
Excel Formula - Count Dates from another Sheet 8
hide multiple worksheets based on a formula value in one cell 1
Excel Count number of instances in a column 1

Back
Top