Search for words

[Asheesh]

Guys, I am somehow not able to crack this one...

I have list of files in column A and if the file name contains the word "Final" then the column B should show "Priority 1", if the file name contains the word "Draft" it should show "Priority 3" in column B otherwise "Priority 2"

Note: it has to be a formula not a vba solution

See the attached...

Appreciate your help in advance

 

[eibi]

Does this do it:

=IF(ISNUMBER(FIND("Final",A2)),"Priority 1",IF(ISNUMBER(FIND("Draft",A2)),"Priority 3","Priority 2"))

 

[John Jairo V]

Hi @Asheesh

This can be an option:
="Priority "&2-ISNUMBER(SEARCH("Final",A2))+ISNUMBER(SEARCH("Draft",A2))

Blessings!

 

[Khalid NGO]

Hello Asheesh,

This one too:
=IF(ISNUMBER(FIND("Final",A2)),1,IF(ISNUMBER(FIND("Draft",A2)),3,2))
format the cells as:
"Priority "#

Regards,

 

[Asheesh]

Thank you guys...