#SPILL!

New Contributor

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?

5 Replies

@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  Without more info this is just a guess at what you want:

=IFERROR(INDEX(MainDB.xlsx!Main[APPID],MATCH([@VPPID],MainDB.xlsx!Main[VPPID],0)),"")

@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!