If(is number... Help

[Toastis]

=IF(ISNUMBER(SEARCH("Amigo",U:U )),"A")

How can i make that show Sundial =S and Giant =G instead of only Amigo = A and everything else false?

AMIGO MART #864 - CONOCO 6 A
SUNDIAL STORE #1 - PHILLIPS 6 FALSE

 

[Akashwani]

Hi,

Do you mean like this?....

Excel Workbook
	A	B
1	Test	Result
2	Amigo Go Go	A
3	Sundance	FALSE
4	Sundial	S
5	Giant Frog	G
6	Green Giant	G
7	Amego	FALSE
8	Sundile	FALSE
Sheet1

I hope that works for you.

Ak

 

[Toastis]

I tired every combination BUT that one! Works perfectly, thanks!

 

[Haseeb Avarakkan]

Also try,

B2, copy down.

=IF(COUNT(SEARCH({"Amigo","Sundial","Giant"},A2)),LEFT(A2))

 

[Toastis]

Haseeb I think you read my mind. Thank you Thank you Thank you!