I want to use the VLOOKUP function. The function will reference a different tab in the workbook to return values on the "Main" tab. I have a list of identifiers which are static that I will use on a quarterly basis, so there may not be values for certain identifiers quarter-over-quarter. The VLOOKUP function returns a #N/A if it does not find a match. However, I need to calculate a year-to-date amount on the "Main" tab, but cannot do so because of the #N/A. Is there a way to have the function return a value of zero versus #N/A so the sum formula on my "Main" tab will calculate a number? Here is the formula I am using: (=VLOOKUP(A6,'Q4 2015'!$A$2:$B$100,2,FALSE). I hope all this makes sense. Thank you!