Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions |