Wildcard in VLookup. Appropriate?

[Ark68]

Is this a proper statement?

.Range("K8") = Application.VLookup("D*CUE2", lurange1, 8, False)

I'm not certain I can use a wildcard in this context. In fact, I'm not sure it's even the right formula for what I want to do.

I want to vlookup either "DRCUE2" OR "DTCUE2", whichever the vlookup finds first.

 

[RoryA]

Is lurange1 a Range object declared in your code? (? might be a better wildcard than * here)

 

[Ark68]

Thank you Rory for your reply. 'lurange1' is declared as a range object, yes. The suggestion of using '?' over the '*' wildcard appears to have done the trick. I will have to continue to test.

I appreciate your help.