Setting up VLOOKUP correctly

Options

Hello,

I have a source sheet that has a unique ID, and I use that as a reference to generate a number of references in a second sheet for extra details. I am using VLOOKUP to bring about 10 columns from the source sheet into the second sheet. The typical formula looks like this:

=VLOOKUP([AOP ID]@row, {2023 AOP Entry Range 1}, 7, false)

where the range is in the source sheet. I get why, but every time I insert a new column into the source table, it messes up my absolute column reference (in this case above, "7") and I have to go back a fix every vlookup. So now to the question:

I know there are some ways in excel do to INDEX and MATCH so I don't break my formulas every time. Is there something similar in SmartSheet? Apologies for the amateur question. I'm still getting my SmartSheet legs.


Thanks,

Brian

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!