VLOOKUP Wildcard

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

Fernando Duran

I have VLOOKUP function, because I have some codes, that I used for
differents rates... so, if I pick-up 96714, I get code rate 124 if I
add an * (96714*) i get rate table 224... but one problem... if a
enter only the "*" i get the same table, which is wrong, every zip
code is different... any solutions...

Fernando
 
Hi Fernando
you may post the formula you're using currently
Try adding the 4th parameter to your current formula. e.g.
=VLOOKUP("*",range,row_index,0)
 
The formula is very simple

=IF(ISNA(VLOOKUP(C7,Postal,2,FALSE)),"WRONG
CODE",VLOOKUP(C7,Postal,2,FALSE))
 
Back
Top