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

mtarler

Silver Contributor

Nov 10, 2020

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)),"")

Pianoman
Copper Contributor
Nov 11, 2020
mtarler Thanks. I did work it out in the end.