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?
--
Rob

Just need the quotes..

=VLOOKUP("400-???",AA33:AB141,2,FALSE)

"Rob947" wrote:

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?
--
Rob

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

--
Thanks,
Shane Devenshire


"Rob947" wrote:

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?
--
Rob

That solved the problem Thanks
--
Rob


"Sean Timmons" wrote:

Just need the quotes..

=VLOOKUP("400-???",AA33:AB141,2,FALSE)

"Rob947" wrote:

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?
--
Rob