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?