Mar 06 2023 02:13 PM
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)
Mar 06 2023 02:45 PM
=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"))