If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"*"
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 |
#2
|
|||
|
|||
"*"
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) -- Regards Frank Kabel Frankfurt, Germany Fernando Duran wrote: 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 |
#3
|
|||
|
|||
"*"
The formula is very simple
=IF(ISNA(VLOOKUP(C7,Postal,2,FALSE)),"WRONG CODE",VLOOKUP(C7,Postal,2,FALSE)) On Mon, 5 Apr 2004 18:00:58 +0200, "Frank Kabel" wrote: 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) |
#4
|
|||
|
|||
"*"
On Mon, 5 Apr 2004 18:00:58 +0200, "Frank Kabel"
wrote: 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) |
Thread Tools | |
Display Modes | |
|
|