When using VLOOKUP, and there is no information to pickup, the cell should not show "0"

**artner0112** · 04-27-2017, 06:19 AM

Hi,

I have attached a file for better understanding.

When ever I use the VLOOKUP function, and there is no information to pull up(VLOOKUP) then the cell show the number 0.
But I want to cell to be blank.

Could somebody show me how to do it?

Thank you for any help.

**PFDave** · 04-27-2017, 06:25 AM

try:

Formula:

Please Login or Register  to view this content.

**artner0112** · 04-27-2017, 10:43 PM

PFDave, Thank you for your help!
This is exactly what I wanted.
PS: Sorry for my late response.

**sandy666** · 04-27-2017, 11:00 PM

[deleted]
I misread above

=IFERROR(IF(Sheet2!D9="","",VLOOKUP(C2,Sheet2!$C$1:$D$100,2,0)),"")
or
=IFERROR(IF(Sheet2!D9="","",INDEX(Sheet2!$C$9:$D$100,MATCH(C2,Sheet2!$C$9:$C$100,0),2)),"")

**sandy666** · 04-28-2017, 10:58 PM

Thanks for the feedback

When using VLOOKUP, and there is no information to pickup, the cell should not show "0"

LinkBack

Thread Tools

Rate This Thread

Display

When using VLOOKUP, and there is no information to pickup, the cell should not show "0"

Re: When using VLOOKUP, and there is no information to pickup, the cell should not show "0

Re: When using VLOOKUP, and there is no information to pickup, the cell should not show "0

Re: When using VLOOKUP, and there is no information to pickup, the cell should not show "0

Re: When using VLOOKUP, and there is no information to pickup, the cell should not show "0

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Cell AF5 to show "specfic text" from AI5:AI62 if M5 IS "155 X 220"

If "6343" in cell A3 matches "monthly" in B3 show a "Y" in C3

[SOLVED] Get Back "#N/A" When work out "relative ratio" by PIVOT's "Show Value as /Difference from"

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

How to add a "Y" to a column cell when other cells with the same site reference show a "Y"

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working

if "a" selected from dropdown menu then show "K" in other cell

Bookmarks

Bookmarks

Posting Permissions