Dear experts
I have list of data in col G:G Which comes along with key code words need to replace by approximate match string values of text.
some time with in cell contains multiple code values P22, P28,P29, P30 result should M&A
like Withholding Tax - CODE word is C44 : Miscellanious expense - C44 Expected result (Miscellaneous ( within EMEA trf) - C44)
Find the attachment
In H2 Cell
=IFERROR(LOOKUP(2,1/SEARCH($A$3:$A$19,G2),$B$3:$B$19),G2)
Drag it down
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Dear sir
can i have vba? i want get value replace on same col G:G
Last edited by johnlara; 11-18-2015 at 10:05 AM. Reason: reason
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks