Multiple columns using same datatable to lookup values

Hello everyone,

I have a sheet that stores part numbers / stock codes. There are 5 columns that have a part number.

The "master" part number list has 45K records, and I have successfully stored this as a datatable. I have also linked this datatable to one column in my sheet, using the stock code, to look up the description.

How do I use the same datatable to look up descriptions for the other four columns? I can only create one connection, and that locks it into one column. And using a lookup sheet doesn't work because we have 45K rows.

Can I specify a datatable in a VLOOKUP function?

Thanks in advance for your help.




  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Can you post the headers of your columns?

    I think it might be possible to do a (long) nested IF statement based on the "not found" portion of your formula - basically if the "not found" value is the result of doing your VLOOKUP, do a VLOOKUP on the next set of columns (obviously this wouldn't apply to the last one), if it isn't the result, then do the VLOOKUP normally to get the desired result.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!