do not want a value if vlookup is false

alethea2000

Board Regular
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

Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

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

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

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

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))

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

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.

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

Replies
30
Views
351
Replies
9
Views
384
Replies
2
Views
293
Replies
10
Views
442
Replies
3
Views
369

1,203,487
Messages
6,055,713
Members
444,810
Latest member
ExcelMuch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back