Forum Discussion
IF OR help
Hi need some help please! how do I combined these 2 formula's: =IF(B6="BEAST",VLOOKUP(A6,'V2 W'!$A:$C,3,FALSE),0) =IF(B6="BUBBLE",VLOOKUP(A6,'V2 W'!$A:$C, 3),0)
=IFS(B6="BEAST",VLOOKUP(A6,'V2 W'!$A:$C,3,FALSE),B6="BUBBLE",VLOOKUP(A6,'V2 W'!$A:$C,3),TRUE,0)
or if B6 is either BEAST, BUBBLE or blank:
=IF(B6="", 0, VLOOKUP(A6, 'V2 W'!$A:$C, 3, B6="BUBBLE"))