Forum Discussion

112233375's avatar
112233375
Copper Contributor
Mar 06, 2023

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)

 

excel

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 06, 2023

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

Resources