Home

IF/THEN or SEARCH/REPLACE Formula Assistance Needed

%3CLINGO-SUB%20id%3D%22lingo-sub-909268%22%20slang%3D%22en-US%22%3EIF%2FTHEN%20or%20SEARCH%2FREPLACE%20Formula%20Assistance%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909268%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20a%20search%20if%2Fthen%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20Column%20A%20contains%20a%20keyword%20from%20Column%20E%2C%20the%20Value%20from%20Column%20F%20is%20copied%20to%20a%20blank%20Column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20840px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137201i3D4F183017B45F19%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Formula.PNG%22%20title%3D%22Excel%20Formula.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-909268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909284%22%20slang%3D%22en-US%22%3ERe%3A%20IF%2FTHEN%20or%20SEARCH%2FREPLACE%20Formula%20Assistance%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424568%22%20target%3D%22_blank%22%3E%40KellyPoling%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIFNA(INDEX(F%3AF%2CMATCH(1%2CINDEX(ISNUMBER(SEARCH(E%3AE%2CA2))*(E%3AE%26lt%3B%26gt%3B%22%22)%2C0)%2C0))%2C%22no%20such%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Ein%20B2%20and%20drag%20it%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909311%22%20slang%3D%22en-US%22%3ERe%3A%20IF%2FTHEN%20or%20SEARCH%2FREPLACE%20Formula%20Assistance%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909311%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B-%20Thank%20you%20so%20much!%20That%20worked%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-909510%22%20slang%3D%22en-US%22%3ERe%3A%20IF%2FTHEN%20or%20SEARCH%2FREPLACE%20Formula%20Assistance%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909510%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F424568%22%20target%3D%22_blank%22%3E%40KellyPoling%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
KellyPoling
New Contributor

I need help with a search if/then formula. 

If Column A contains a keyword from Column E, the Value from Column F is copied to a blank Column B.

 

Excel Formula.PNG

3 Replies

@KellyPoling 

That could be

=IFNA(INDEX(F:F,MATCH(1,INDEX(ISNUMBER(SEARCH(E:E,A2))*(E:E<>""),0),0)),"no such")

in B2 and drag it down

@Sergei Baklan - Thank you so much! That worked

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies