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?
|