Help using wildcards in VLOOKUP

[cr731]

Hi

I am trying to use wildcards in the table array of a vlookup but I am not having success. Is this possible? I want do the following:

Lookup value: 45123

Table:

Col 1 Col 2
??123 56
??124 57

So... I would want my vlookup to search for 45123, and I would think that ??123 would be a match, since ?? is the wildcard, and then return 56. Am I not understanding how wildcards are used? Can this not be done?

Thanks

 

[Aladin Akyurek]

Thanks again! I would never have thought to use INDEX that way.

You are welcome.