I have attached an example of what I am trying to do. I have columns in a sheet that are based on a VLOOKUP. I have another column that I need to populate based on the results of one of the VLOOKUP columns.

Or is there are way I could write an IF function and list all 50 states and what the name should be for each state?

Many thanks for any help!

Best Answers


  • Thank you! I did not think I could do a VLOOKUP with my search value being from another VLOOKUP. I will try this.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!