Hi,
I am trying to get the below formula to work. I don't know what I am getting wrong over here. Can someone please help with the same.
=IFS(M3="",O3,O3="",R3),IFNA(VLOOKUP(M3,'Sponsor List Ref'!B2:C95,2,0),VLOOKUP(M3,'Sponsor List Ref'!$F$2:$G$6,2,0)))
The formula works well with only IFNA part, but if i add the IFS before, it gives a #Value! error. Any input is appreciated.
Thanks.
I am trying to get the below formula to work. I don't know what I am getting wrong over here. Can someone please help with the same.
=IFS(M3="",O3,O3="",R3),IFNA(VLOOKUP(M3,'Sponsor List Ref'!B2:C95,2,0),VLOOKUP(M3,'Sponsor List Ref'!$F$2:$G$6,2,0)))
The formula works well with only IFNA part, but if i add the IFS before, it gives a #Value! error. Any input is appreciated.
Thanks.