Using Index/Match to fill out document

I am trying to use INDEX/MATCH functions to gather the items and quantities to go onto a printed document.

I’ve gotten as far as this function: =INDEX({InventoryIndex}, MATCH($[IndexKey created with a different function]@row, {column in the index with all the index keys}, 0))

My question: Is there a way for the function to start in a row and skip items with a blank QTY? The next column to be filled would then pick up where the previous left off until all items with a QTY in the row have been placed?

Bonus question: Have I overlooked some obviously easier way to accomplish this goal? I’m 3 months new to this and the index is only about a 25% finished. So it's definitely not too late change tactics but I have no idea if I’m making this overly difficult on myself or if this is a reasonable way to do things. 😅

Find more posts tagged with

Accepted answers

BullandKhmer

You could probably use a nestled if statement combined with multiple index matches, something like that.

All comments

Christian G.

Hi @Coffee

Can you send a screenshot of what you try to accomplish?

Coffee

This is the (test version of the) sheet that generates the form

This is the sheet that the index is referring to

Current formula in each column of the first image is: =INDEX({INDEX}, MATCH($[MATL QTY Key]@row, {INDEXKEY}, 0), 1)

What I'm trying to figure out is if there's a way to have it skip blank columns on the index and then the next QTY column picks up where the previous left off. So, if QTY 7 has to go all the way to column 22 to get a value, then QTY 8 would start in column 23.

BullandKhmer

You could probably use a nestled if statement combined with multiple index matches, something like that.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.