| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Names with If function
I can give it a try. Thanks
"Ron Coderre" wrote: Try something like this (in sections for readability): =IF(A10="","",INDEX({"555-1111","555-2222","555-3333","555-4444"}, MATCH(A10,{"Alpha","Bravo","Charlie","Delta"},0))) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Dgwood90" wrote in message ... This is the formula I am using. =IF(A10=Steve Smith,555-555-5555,IF(A10=John Adams,555-555-5555,"")). I am using four names. "FSt1" wrote: hi i think so. post your formula. regards FSt1 "Dgwood90" wrote: I have created a drop down list of names. I am now trying to create an IF function, that when a certain name is selected from the drop down box, it will populate with a phone number. I receive the #NAME error. Can I not use names with IF function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where to find translation of the names of the function | Excel Discussion (Misc queries) | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| Looking for function to pick out names and at values from the same row | New Users to Excel | |||
| Translating function names | Excel Discussion (Misc queries) | |||
| Is there a function that allows me to list the names of excluded d | Excel Worksheet Functions | |||
Threaded Mode
