do not want a value if vlookup is false

[alethea2000]

Hi

I am doing a vlookup but if the thing i am looking up is not there i want it to come back with nothing or a work saying no, how can i do this please. thanks ali

 

[NBVC]

Add the error handling portion:

=If(ISNA(Vlookup(....),"",Vlookup(...))

 

[razzandy]

How about this:

=IF(A4<>"",VLOOKUP(Sheet1!$A$4,Sheet2!$L:$U,10,FALSE),"")

 

[alethea2000]

thank you for your help but i cannot seem to get this to work, error my side

my formula currently is
=VLOOKUP(B2,EmpDB.xls!$C$2:$D$9494,2)

how should this look. thank again

 

[NBVC]

Try copying this to your sheet.

=If(isna(VLOOKUP(B2,EmpDB.xls!$C$2:$D$9494,2,0)),"",VLOOKUP(B2,EmpDB.xls!$C$2:$D$9494,2,0))

 

[alethea2000]

EXCELLENT THANKS TO YOU BOTH I HAVE USED

=If(isna(VLOOKUP(B2,EmpDB.xls!$C$2:$D$9494,2,0)),"",VLOOKUP(B2,EmpDB.xls!$C$2:$D$9494,2,0))

I have never hear of isna before what does it mean.

thanks again

 

[NBVC]

It means if the value you are looking for is not available (hence ISNA), then return what you asked for, ("") else return the value your looking for.

Look in the Function dialogue, under the Inforation Category for further help.

 

[Aladin Akyurek]

What does EmpDB.xls!$C$2:$D$9494 house? And is it sorted on column C in ascending order?