"*"

[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

 

[Frank Kabel]

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)

 

[Fernando Duran]

The formula is very simple

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