Find, Lookup, who knows???

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

I have a list if items and wish to find and item by partical name. How can
I do this using VB code?

Item345 1 6
*Item124 2 7
Item346 3 9

I wish to do a VB search for "*Item" and return the values 2 and 7.

Note that in Column A I only wish to look at left$ 5 characters on the find.

Thank you for your help in advance!!! (smile)

Mike
 
use vlookup or match/index function which can be used in vba
range("c1")=application.vlookup(item,range("a2:d400"),2,false)

or use find and offset in vba
 
But how can I do a partical search on a field, this only works it what I am
finding is the entire word.

How do I do a loop search inside of VB on an area?

Mike
 
try this

Sub findfirstfive()
Dim myvar As String
myvar = "item1"
x = Range("e10:e112").Find(myvar, lookat:=xlPart).Address
MsgBox Range(x).Offset(, 1)
End Sub
 
Back
Top