Correct syntax for Worksheetfunction.vlookup?

[skulakowski]

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]

Tier = WorksheetFunction.VLookup(valLookup, Sheets("data").Range("TierRange"), 2, True)

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

:)

[skulakowski]

I get Runtime error 1004: unable to get the Vlookup property of the WorksheetFunction class.

I'm running Excel 2003.

[Zack Barresse]

Can you post all your code or upload a sample file?

[skulakowski]

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]

Go figure: T's not a number.
ROFL!! :rofl:

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