Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Using LOOKUP function on a sheet with a form to add rows

Options
darin_schnitzer
darin_schnitzer ✭✭✭
edited 12/09/19 in Archived 2017 Posts

I am having some trouble with using the LOOKUP function on a sheet I have. We want to use a form to create a ad placement name that includes abbreviations of what the user selects. I am finding that the LOOKUP area shifts as new rows are added. I set all my lookup tables at the top of a sheet and then the new rows are added at the bottom. As the formula duplicates, the LOOKUP range shifts down too causing my naming to not work. Is there a way to lock in the LOOKUP range?

Comments

This discussion has been closed.