SOLVED

IF & VLOOKUP together

%3CLINGO-SUB%20id%3D%22lingo-sub-2637967%22%20slang%3D%22en-US%22%3EIF%20%26amp%3B%20VLOOKUP%20together%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2637967%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20pull%20data%20from%20one%20spreadsheet%20to%20another.%26nbsp%3B%20I%20am%20using%20a%20VLOOKUP%20formula%20which%20is%20working%20except%20for%20those%20lines%20that%20are%20not%20finding%20a%20match%20in%20the%20second%20spreadsheet%2C%20it%20is%20giving%20me%20an%20%23N%2FA%20error.%26nbsp%3B%20I%20need%20to%20put%20a%20zero%20in%20the%20field%20if%20there%20is%20no%20match%20and%20I%20can't%20figure%20out%20how%20to%20use%20the%20IF%20and%20VLOOKUP%20together%20to%20make%20that%20work.%26nbsp%3B%20Can%20someone%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2637967%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2638053%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20%26amp%3B%20VLOOKUP%20together%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2638053%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1126325%22%20target%3D%22_blank%22%3E%40blackmonhoustonhospice%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20IFNA()%20or%20IFERROR().%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2638124%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20%26amp%3B%20VLOOKUP%20together%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2638124%22%20slang%3D%22en-US%22%3EThanks.%20I%20just%20found%20IFERROR%20and%20it%20works.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to pull data from one spreadsheet to another.  I am using a VLOOKUP formula which is working except for those lines that are not finding a match in the second spreadsheet, it is giving me an #N/A error.  I need to put a zero in the field if there is no match and I can't figure out how to use the IF and VLOOKUP together to make that work.  Can someone help me?

4 Replies
best response confirmed by blackmonhoustonhospice (New Contributor)
Solution

@blackmonhoustonhospice 

Use IFNA() or IFERROR() or XLOOKUP().

 

Thanks. I just found IFERROR and it works.
I'm not clear how to integrate the IFNA() or IFERROR() part of the formula. Could someone show me how this would work for my spreadsheet? This is my formula
=VLOOKUP(A3,'ITEM LIST'!A$2:C$1050,3,FALSE)

@chrisstgermain 

Simply.

=IFERROR(VLOOKUP(A3,'ITEM LIST'!A$2:C$1050,3,FALSE),"mo match")