|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
06-16-2009, 01:20 PM
|
#1 (permalink) |
|
Registered User
Join Date: Sep 2003
Posts: 13
OS: xp
|
EXCEL Auto fill
I'd like to have a specific cell automatically list info based on what gets entered into another field.
Example: G16 starts with 3 then cell G18=AMEX G16 starts with 4 then cell G18=VISA G16 starts with 5 then cell G18=MASTERCARD I think this might be a conditional format, but I must have brain drain today. Thanks. Dana
__________________
Dana |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
06-16-2009, 06:06 PM
|
#2 (permalink) |
|
TSF Enthusiast
Join Date: Apr 2008
Location: Australia
Posts: 559
OS: Vista
|
Re: EXCEL Auto fill
Hi Dana,
Using a lookup table is often the best approach but, provided there's no more than 8 possible outcomes, you can also do it with a set of up to 7 nested IF tests in G18: =IF(G16=3,"AMEX",IF(G16=4,"VISA",IF(G16=5,"MASTERCARD","N/A")))
__________________
Cheers macropod (MS MVP -Word) |
|
|
|
|
| Thread Tools | |
|
|
