Forum Discussion

Copper Contributor

Nov 10, 2020

#SPILL!

I'm using the following formula: =IFERROR(IF(MATCH([@VPPID],MainDB.xlsx!Main[VPPID],0),MainDB.xlsx!Main[APPID],""),"") and I'm getting a #SPILL! error. Can anyone help?

excel

Formulas and Functions

office 365

Subodh_Tiwari_sktneer

Silver Contributor

Nov 10, 2020

Pianoman

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
Copper Contributor
Nov 11, 2020
Subodh_Tiwari_sktneer Thanks. I did work it out in the end.
- Subodh_Tiwari_sktneer
  Silver Contributor
  Nov 11, 2020
  You're welcome Pianoman!