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.

Craig

Find more posts tagged with

DataTable

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.