Linking Data into Cells

P

Patti

If you only have a few choices, you can use a nested "If"
statement:

=If(A1="Mid_Coast", "ME080100",if
(A1="Southern_Maine","ME080300",0))

If you have a lot of choices, you can use a "Lookup"
statement. How many do choices are there?
 

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

Page numbering with Merged Document and IF statements 1
Excel - Wich Function should I use? 1
IF statement reference 1
Drop Downs, Index Match or what? 56
How to create skip pattern in access 2013 form 0
Office365 Family + TXT or MX Domain 0
Simple nested if and statement 2
Use Vlookup to store formulas? 6

Top