Forum Discussion
Solved
Need help with Excel formula
=IFERROR(INDEX(TBL_REG[Appointment Effective Date],MATCH(TBL_SF[@[License '#]],TBL_REG[License Number],0)),"!-No Match") Need some help with this formula. It works fine however, in the TBL_REG t...
As I noted, FILTER will return multiple values/lines if multiple match. If you have that case then add either an INDEX or a TAKE to only output the 1st match:
=TAKE(FILTER(TBL_REG[Appointment Effective Date], (TBL_SF[@[License '#]] = TBL_REG[License Number])*(TBL_SF[@[State]] = TBL_REG[State]), "!-No Match"),1)
appreciate the effort. that resulted in #SPILLL!
As I noted, FILTER will return multiple values/lines if multiple match. If you have that case then add either an INDEX or a TAKE to only output the 1st match:
=TAKE(FILTER(TBL_REG[Appointment Effective Date], (TBL_SF[@[License '#]] = TBL_REG[License Number])*(TBL_SF[@[State]] = TBL_REG[State]), "!-No Match"),1)
that looks like it works. Thanks so much !