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