vlookup problem

[ringmaster]

hi all

I have a vlookup problem with the dutch version of excel
this is the code that supposed to work but no excel says there is an error

=ALS(ISNB(VERT.ZOEKEN($B$25;Blad3!$A$1:$B$3;2;0)),"Leeg",VERT.ZOEKEN($B$25;Blad3!$A$1:$B$3;2;0))
the error starts at and ends here ,"leeg",VERT.ZOEKEN

What i'm doing wrong ?

If=Als ISNA=ISNB VLOOKUP=VERT.ZOEKEN


greetzz

Anco

 

[erik.van.geit]

Hello, ringmaster,
Welcome to the Board !!!!

On the main page of Excel Questions there is a link
Recommended Add-ins and Links where you will find a formula-translator: this can be handy posting formulas here

do you have commas in your formula ?
you should have ";"
=ALS(ISNB(VERT.ZOEKEN($B$25;blad3!$A$1:$B$3;2;0));"Leeg";VERT.ZOEKEN($B$25;blad3!$A$1:$B$3;2;0))
english

=IF(ISNA(VLOOKUP($B$25,blad3!$A$1:$B$3,2,0)),"Leeg",VLOOKUP($B$25,blad3!$A$1:$B$3,2,0))

if you want to ask your question in Dutch: go to the International Forum

NOTE: you didn't reply yet to the response you got in your first post, would be better to do so to my sense :wink:

kind regards,
Erik

 

[ringmaster]

Thanks Eric it works Great !!
Strange but the excel help says commas on the fromula i used very wierd
microsoft error i think

Thanks for the info