Nov 10 2020 02:33 AM
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?
Nov 10 2020 04:27 AM - edited Nov 10 2020 04:29 AM
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.
Nov 10 2020 07:27 AM
@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)),"")