I am trying to use a vlookup to calculate averages across multiple sheets. I think I am close to getting the formula right, my only issue is records in Column A on my summary sheet are not returning a value if the record is not on both sheets. Cell B5 for example. What am I missing here? Thanks in advance.