Match
Hi All,
i have value B_12-23 it should match with B_12-23 B_12 23 B 12 23 B1223 I need vba solution. Thanks in advance. |
Match
Hi
Maybe this is what you need: Sub MyMatch() Set TargetRange = Range("A1:A4") Set MatchCell = Range("B1") MatchValue = WorksheetFunction.Match(MatchCell, TargetRange, 0) MsgBox ("Match is : " & MatchValue) End Sub Regards, Per "fi.or.jp.de" skrev i meddelelsen ... Hi All, i have value B_12-23 it should match with B_12-23 B_12 23 B 12 23 B1223 I need vba solution. Thanks in advance. |
Match
As I am sure there are other letters and numbers besides "B", "12, and "23"
that you will need to match, then let's call your B_12-23 value Code and your other possible values TextVal; then your test would be this... If Replace(Replace(Code, "-", ""), "_", "") = _ Replace(Replace(TextVal, "-", ""), "_", "") Then MsgBox "They match" Else MsgBox "They do not match" End If Know though that this is not a foolproof test as TextVal's like B-1_2-2_3 would also show up as matching the Code value B_12-23. Only you know if this is a "good" enough test as only you know the possible Code and TextVal values that can be in your data. Other more exacting tests might be possible, but you would have to tell us about any restraints regarding the "shape" that the Code and TextVal's could possibly take. -- Rick (MVP - Excel) "fi.or.jp.de" wrote in message ... Hi All, i have value B_12-23 it should match with B_12-23 B_12 23 B 12 23 B1223 I need vba solution. Thanks in advance. |
Match
Thanks Rick,
I was waiting on my last post. On Oct 7, 11:44*am, "Rick Rothstein" wrote: As I am sure there are other letters and numbers besides "B", "12, and "23" that you will need to match, then let's call your B_12-23 value Code and your other possible values TextVal; then your test would be this... If Replace(Replace(Code, "-", ""), "_", "") = _ * * *Replace(Replace(TextVal, "-", ""), "_", "") *Then * MsgBox "They match" Else * MsgBox "They do not match" End If Know though that this is not a foolproof test as TextVal's like B-1_2-2_3 would also show up as matching the Code value B_12-23. Only you know if this is a "good" enough test as only you know the possible Code and TextVal values that can be in your data. Other more exacting tests might be possible, but you would have to tell us about any restraints regarding the "shape" that the Code and TextVal's could possibly take. -- Rick (MVP - Excel) "fi.or.jp.de" wrote in message ... Hi All, i have value B_12-23 it should match with B_12-23 B_12 23 B 12 23 B1223 I need vba solution. Thanks in advance. |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com