Forum Discussion

Alaa_Ajaj's avatar
Alaa_Ajaj
Copper Contributor
Mar 27, 2023

Search for text using nested IF

I wanna use nested IF(AND(SERACH formula to find the first letter on the left in B:B column based on the statues on C:C column and return the product name (SONY and VOLVO) in Condition 1 column if it...
Excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 27, 2023

Alaa_Ajaj 

=IF(AND(LEFT($B3,1)="V",$C3="Sell",ISEVEN(COLUMN())),"Volvo",IF(AND(LEFT($B3,1)="S",$C3="Sell",ISEVEN(COLUMN())),"Sony",IF(AND(LEFT($B3,1)="V",$C3="Buy",ISODD(COLUMN())),"Volvo",IF(AND(LEFT($B3,1)="S",$C3="Buy",ISODD(COLUMN())),"Sony",""))))

You can try this nested IF formula.

 

Aladdin_Ajaj's avatar
Aladdin_Ajaj
Copper Contributor
Mar 27, 2023
Thank you very much it worked perfectly

Resources