Forum Discussion
Need help with Excel formula
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)
You might consider using FILTER. NOTE that FILTER can and will return multiple values/lines if multiple match:
=FILTER(TBL_REG[Appointment Effective Date], (TBL_SF[@[License '#]] = TBL_REG[License Number])*(TBL_SF[@[State]] = TBL_REG[State]), "!-No Match")
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 !
