Below is what I've writtem so far:

Sub vlookup()

Dim myrange As Range

Set myrange = Workbooks("first.xls").Worksheets("sheet1").Range("list")

fred = Application.WorksheetFunction.vlookup(Range("a1"), myrange, 2, True)

Range("b1") = fred

End Sub

The contents of "first.xls" has numbers 1 to 10 in column A and letters a to i in column B.

My issue is if I change the 'true' value to 'false' within the vlookup function. It works fine until I enter a value that is not in my list, I get a 'error 1004 unable to get the vlookup property of the worksheetfunction class' message box come up. I am expecting a '#N/A' instead.

I'm using excel 2003 with vb 6.3.

Any ideas?