Get rid of the 0 in a Vlookup

PvtSmity

New Member
Joined
Jul 26, 2016
Messages
13
Hi All,
I hope that you can help. I have 4 tabs on this sheet. 1st tab is my shipping info that I drop into the sheet and 3 of them have info I need to reference from. The problem is I keep getting 0 on half my look ups. So I tried to use =IFNA(IF(VLOOKUP(A2,'Redding '!A:P,16,FALSE)=0,"",VLOOKUP(A2,'Redding '!A:P,16,FALSE)),"") Which need deed did work but how do I combine the other 2 tabs to find all the info I need. So I tried this way

=IFNA(IF(MATCH(A2,'Redding '!A:A,0),VLOOKUP(A2,'Redding '!A:R,15,FALSE),IF(MATCH(A2,'Mound City-Tecate'!A:A,0),VLOOKUP(A2,'Mound City-Tecate'!A:Q,15,FALSE),IF(MATCH(A2,'Tecate-Sewing'!A:A,0),VLOOKUP(A2,'Tecate-Sewing'!A:Q,15,FALSE),""))),"")

But then I'm getting those darn 0's again.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,892
Office Version
2007
Platform
Windows
Try this

=IFERROR(VLOOKUP(A2,Redding!A:O,15,0),IFERROR(VLOOKUP(A2,'Mound City-Tecate'!A:O,15,0),IFERROR(VLOOKUP(A2,'Tecate-Sewing'!A:O,15,0),"Does not exist")))
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,892
Office Version
2007
Platform
Windows
I'm glad to help you. Thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,886
Messages
5,471,313
Members
406,755
Latest member
CalJake

This Week's Hot Topics

Top