Forum Discussion

ElRafaVaz33's avatar
ElRafaVaz33
Copper Contributor
Jun 20, 2022

Referencing all non-blank values in a row/column

Hello Microsoft Community,   I've been building up a large worksheet that has several sheets using functions such as XLOOKUP & VLOOKUP from a series of tables. I expect to use this sheet for severa...
Excel on Mac
Formulas and Functions
office 365
ElRafaVaz33's avatar
ElRafaVaz33
Copper Contributor
Jun 20, 2022
Hey Sergei, not sure I understand; what do you mean by a structured table with a per-row reference? when I've tried mixing tables and references I've always gotten a spill error; is this a different type of table?
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 21, 2022

ElRafaVaz33 

I mean the difference between these two formulae

Not sure which one do you use.

  • ElRafaVaz33's avatar
    ElRafaVaz33
    Copper Contributor
    Jun 21, 2022
    I see! I always attempted the first instance, let me try the second and see if it works.

    Thanks Sergei!

Resources