hello
i have a data base of 1500 rows.i am trying to return an item from the list using vlookup function.
QUOTE
Function FindTechNumber(num)
On Error Resume Next
With Worksheets("projects")
FindTechNumber = Application.VLookup(num, Range("A1:D1750"), 3, False)
End With
End Function
what is wrong with specifing a range and using the vlookup to return an item
thanks
moshe
| 
