Vlookup returning 0\'s instead of blanks when no data evident I am bringing data

Question

Vlookup returning 0's instead of blanks when no data evident

I am bringing data from one sheet to another based on matched ID's. Where the ID doesn't exist it is returning blanks or #N/A which is fine, but if the ID exists and the cell I am looking at is blank it return a 0 instead of a blank - some of my cells have 0 in them so I can't differentiate between what should be a 0 and what should be a blank. See example below?

using the formula of =VLOOKUP(A2,...,2,FALSE) etc. it's returning this:

whereas I want the highlighted zero's to be blank - any ideas???

Thanks !

ID Service 1 Number Minutes Service 2 Number Minutes 10-101 Service Type A 2 70 Service TYPE B 4 120 10-102 Service TYPE B 1 30 10-103 Service TYPE B 1 45 10-104 Service TYPE B 1 60 Service Type C 2 0 10-105 Service Type A 1 0 Service TYPE B 2 60 10-106 Service Type C 1 30 10-107 Service TYPE B 1 0 Service TYPE B 1 60

Explanation / Answer

Hi..

> .. if the ID exists and the cell I am looking at is blank it return a 0 instead of a blank
You could try something like this
=IF(VLOOKUP(D1,A:B,2,0)="","",VLOOKUP(D1,A:B,2,0))
to return the desired blanks ("") for matched cases with blanks in the return col

Hope this help !!

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.