Forum Discussion
IFS with VLOOKUP help
IF(OR(IFERROR(IFS(AND(F3=VLOOKUP(F3,'Dropdown list'!N2),F4=VLOOKUP(F4,'Dropdown list'!N2)),"yes",AND(F3=VLOOKUP(F3,'Dropdown list'!O2:O3,1),F4=VLOOKUP(F4,'Dropdown list'!O2:O3,1)),"yes",AND(F3=VLOOKU...
this is similar or same as another post (https://techcommunity.microsoft.com/discussions/excelgeneral/ifs-with-vlookup-not-functioning/4405362)
In this case the Bilirubin Ranges are all unique number/values and assuming F3 and F4 are not blank, I would recommend:
=IF(OR(MMULT({1,1,1},(F3=N2:R4)+(F4=N2:R4))=2),"yes","no")