New Contributor

I'm using the following formula:


and I'm getting a #SPILL! error.

Can anyone help?

5 Replies


That's because if the logical condition is evaluated as True, the formula will return all the values from a column of a table (MainDB.xlsx!Main[APPID]) not a single or scalar value.

@Pianoman  Without more info this is just a guess at what you want:


@Subodh_Tiwari_sktneer Thanks. I did work it out in the end.

@mtarler Thanks. I did work it out in the end. 

You're welcome @Pianoman!