PDA

View Full Version : [SOLVED] Correct syntax for Worksheetfunction.vlookup?



skulakowski
03-04-2005, 10:48 AM
Can anybody help me with the correct syntax for a worksheetfunction.Vlookup?

The idea is this:

Tier = WorksheetFunction.VLookup(data!a & jRow, TierRange, 2, True)

where data!a & jRow identifies the cell and TierRange is a named range.

Zack Barresse
03-04-2005, 11:22 AM
Tier = WorksheetFunction.VLookup(valLookup, Sheets("data").Range("TierRange"), 2, True)

..where valLookup is WHAT you are wanting to lookup.
Unless I misunderstood you.

:)

skulakowski
03-04-2005, 11:40 AM
I get Runtime error 1004: unable to get the Vlookup property of the WorksheetFunction class.

I'm running Excel 2003.

Zack Barresse
03-04-2005, 12:26 PM
Can you post all your code or upload a sample file?

skulakowski
03-04-2005, 12:41 PM
Thank you. Your suggested code worked perfectly. Evidently my problem was that the letter T is not a number. Go figure: T's not a number.

Zack Barresse
03-04-2005, 12:43 PM
Go figure: T's not a number.
ROFL!! :rofl:

It's good you can have a sense of humor about that. :yes