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?

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

@blackmonhoustonhospice 

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

 

Thanks. I just found IFERROR and it works.