Using Wildcards in VLOOKUP

R

Rob947

I am trying to use VLOOKUP to extract data from a table. The format of the
1st column is 3 numerics and then a "-" and 3 more numerics i.e. 400-237.
If I am looking for the 400 call-up I do not care what the last three digits
are so want to use 400-??? but when I put it into VLOOKUP as
VLOOKUP(400-???,AA33:AB141,2,FALSE) I get an error but if I store the
"400-???" in a cell like A1 and use
VLOOKUP(A1,AA33:AB141,2,FALSE) it works. Is there anyway to use wildcards
in the VLOOKUP lookup value?
 
S

ShaneDevenshire

Hi,

You can use any of the 3 wildcard in VLOOKUP and you can do that any of at
least 4 ways:
1. 333-??? in cell A1 using =VLOOKUP(A1,AA33:AB141,2,FALSE)
2. enter the criteria in the formula =VLOOKUP("333-???",AA33:AB141,2,FALSE)
3. by combining these two - entering 333- in one cell and ??? in another cell:
=VLOOKUP(A1&A2,AA33:AB141,2,FALSE)
4. Entering part in a cell and part in the formula in A1 333-
VLOOKUP(A1&"???",AA33:AB141,2,FALSE)

You can use these techniques with ?, *, or ~.

Remember 333-* would return 333-123 and 333-a
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vlookup Help 0
Multiple columns using Vlookup 3
Vlookup to return the next true value 2
create a formula by using text from other cells 1
VLOOKUP problem 3
Some rules about Vlookup REPOSTED 6
vlookup using different workbooks 4
Excel Formula 2

Top