Have you ever had two sets of data on two different spreadsheets that you want to combine into a single spreadsheet? For example, you might have a list of people’s names next to their email addresses in one spreadsheet, and a list of those same people’s email addresses next to their company names in the Read More
Tag: VLOOKUP
How VLOOKUP Return Zero Instead Of #N/A in Excel?
To return zero instead of #N/A when the VLOOKUP function cannot find the correct relative result, you just need to change the ordinary formula to another one in Excel. Select the cell you want to use VLOOKUP function, and type this formula =IFERROR(VLOOKUP(A13,$A$2:$C$10,3,0),0), drag the autofill handle to the range you need. See screenshot: Tips:(1) In Read More