• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Using the Like operator properly

elbrodero

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
#1
I have the following function:

For l = 3 To 100 Step 2
Str3 = Worksheets(2).Cells(l, 1).Value

If Right(Str2, 7) = Right(Str3, 7) Then Worksheets(3).Range("C6").Value = Worksheets(2).Cells(l, 4).Value
Next l

This works quite well, however sometimes I have the case that the value of Str2 has left out two zeros at the end but I would still like to copy the value. I thought of something like:

If "Right(Str2, 7)*" Like "Right(Str3, 7)" Then Worksheets(3).Range("C6").Value = Worksheets(2).Cells(l, 4).Value

But that doesn't work. Do you guys have any idea?
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#2
so the values are something like ABC123456700 but sometimes the 00 are left off and you want to match the remaining 5?
so ABC1234567 = ABC123456700 ?

Something like this might work (have not tested it :)) - maybe using If/elseif
If "Right(Str2, 7)*" Like "Right(Str3, 7)" Then Worksheets(3).Range("C6").Value = Worksheets(2).Cells(l, 4).Value
If "Right(Str2 & "00", 7 )" Like "Right(Str3, 7)" Then Worksheets(3).Range("C6").Value = Worksheets(2).Cells(l, 4).Value
 

Similar threads