TechQA.

Filter blanks from Xlookup search key range

28 views Asked by At

I am using an xlookup function as an arrayformula to sum the prices of ingredients. It functions when the search key I use does not have any blank values, but if there are blank values it errors out. Please see these below screenshots:

Working enter image description here

Not Working enter image description here

What function can I add to allow for blanks under columns D through M?

arrays google-sheets google-sheets-formula lookup
Original Q&A
1

There are 1 answers

2
rockinfreakshow On BEST ANSWER

Just leave the xlookup 4th parameter missing_value either blank OR zero & it should workout.

XLOOKUP(search_key, lookup_range, result_range, missing_value, match_mode, search_mode)

Related Questions in ARRAYS

Related Questions in GOOGLE-SHEETS

Related Questions in GOOGLE-SHEETS-FORMULA

Related Questions in LOOKUP

Popular Questions

Popular Tags

javascript python java c# php android html jquery c++ css ios sql mysql r reactjs node.js arrays c asp.net json

Trending Questions