Apr 25 2020 08:00 PM
Apr 27 2020 01:32 AM
Apr 27 2020 01:50 AM
Apr 27 2020 05:16 AM
Attached is my file.
Apr 27 2020 04:46 PM
Apr 27 2020 06:21 PM
OK, in the attached you have in column C a description with the word sharpertek, I want a formula to search that column, find the keywords I choose and populate Column D for Vendor with in this case the company sharpertek.
Apr 27 2020 06:41 PM
Apr 27 2020 06:42 PM
I know that, but i have over 10000 rows, I am not going through all. I need a formula, or vlookup to do it for me.
Apr 27 2020 06:50 PM
so there is a solution, we can use IF function if the text contain "sharpertek" return as yes and if not so return as no but you have to add one more column and then by adding filter we can easily get that columns which contain "sharpertek" as yes.
Apr 27 2020 06:52 PM
Apr 27 2020 06:52 PM
Ok, and how do I write that function? I am trying to learn.
Apr 27 2020 06:54 PM
i am sending you a sample solution
Apr 27 2020 06:55 PM
I have a column called Vendor which is Column D, some are blank some say Scientific Solutions. I want a formula, that looks at all the text in column C which is the description, and if it finds the word sharptec, then in column d it auto populates the Vendor Sharptec replacing the blank or Scientific Solutions
Apr 27 2020 07:04 PM
Apr 27 2020 07:07 PM
Apr 27 2020 07:14 PM
=IF(ISNUMBER(SEARCH("Sharpertek",C2)),"Sharpertek",IF(D2="","",D2))
GREAT!
it works but simply at a negative part of that formula we can just write blank and any other word
=IF(ISNUMBER(SEARCH("Sharpertek",C2)),"Sharpertek",Blank)
great effort my friend
Apr 27 2020 07:16 PM
Apr 27 2020 07:17 PM
@Khizar_Hayat thank you. The reason for the second nested IF is to not return a zero if the value in that cell is blank.
Apr 27 2020 07:22 PM
ok i got your point
Apr 27 2020 07:27 PM