I'm just beginning to delve into the wild & wacky world of VLookup. To make this very simple, if I have numerical data in column A, lets say 2000 rows, and I want to find the entry of 123.
I name the list in column A "List1".
GetNumber()
Dim SearchNum As Variant
SearchNum = InputBox("Enter the Number")
Sheets("Sheet1").Activate
VLookup(SearchNum, Range("List1"),
MsgBox SearchNum
End Sub
I've tried looking at some samples on this forum, but I'm still trying to get my head around some of the syntax, so I'm not really sure what I'm doing.
I was trying to use a previous code that I'd found as an example, and amend it to suit, but I keep getting an error message (which really doesn't surprise me) 'cos I'm still new at this.
Run-time error 1004
Unable to get the VLookup property of the WorksheetFunction class
In a nutshell....what I'd like is a text box to prompt for the search criteria (in this case...123)
Then some kind of message box to either appear...or preferably...be taken to the actual entry of 123
Any assistance would be much appreciated......and please try to keep the laughter to a minimum....Thanx..