Forum Discussion
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...
hi,
try this
=CHOOSE(($C3=D$2)*((LEFT($B3,1)="v")+(LEFT($B3,1)="s")*2)+1,"","volvo","Sony")
- I got zero values
