#SPILL!

Question

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?

subodh_tiwari_sktneer · Answer

Pianoman&nbsp;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.

mtarler · Answer

Pianoman&nbsp; 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)),"")

pianoman · Answer

Subodh_Tiwari_sktneer&nbsp;Thanks. I did work it out in the end.

pianoman · Answer

mtarler&nbsp;Thanks. I did work it out in the end.&nbsp;

subodh_tiwari_sktneer · Answer

You're welcome Pianoman!

Forum Discussion

#SPILL!

5 Replies

Resources