IF OR help

Copper Contributor

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)

 

1 Reply

@112233375 

 

=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"))