Formula with multiple answers



Is there a formula for a row that can have multiple answers? I have one column A with names, and depending on that name in column A, I want a different number to appear in column B

For example

If column A=Mary, return 245 or column A=James, return 548…..etc.

I have 5 names with 5 different values associated with them

=IF(or(Forename1 "Mary"), RefNum1, "245", IF(or(Forename1, "James"), RefNum1, "548"), … but keep getting #unparseable



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!