I am bringing data from one sheet to another based on matched ID\'s. Where the I

Question

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

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

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

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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