Fill In A Cell

Anthony DAmbrosio

Hello Smartsheet Community,

I wanted to see if there was another way other than a "VLOOKUP" to automatically fill in a cell when a word is picked on a form. I am creating a travel form and what I would like to do is when someone choose their preferred airport code, the name of the airport will automatically pull into my grid. Any and all suggestions are welcomed.

Hope everyone is having a great day.

Best,

Anthony D'Ambrosio

Ryan Sides

@Anthony DAmbrosio

Create a second sheet that lists your codes and names. Then use INDEX/MATCH formula to determine the correct name from your second sheet.

Ryan Sides

@Anthony DAmbrosio

Create a second sheet that lists your codes and names. Then use INDEX/MATCH formula to determine the correct name from your second sheet.