Hi, I'm pretty new to excel and very new to this forum so I'm sorry if this is an easy-to-answer question. My excel vocabulary is probably not the most accurate either, but if you can understand this any help you can provide would be much appreciated thank you!

I'm using VLOOKUP to return and average values from 10 sheets. When I drag the formula it works great, but only for the lookup values that are found in every sheet. Some lookup values are only in 2 or 3 sheets, but instead of giving me the average of those values it returns an error (#N/A).

Is there a way to tell the formula to lookup the values only if the lookup value is found in the sheet? I think that's the easiest way to put it. Thanks again for reading and hopefully I don't have to go in and edit each formula manually haha.

Cheers,
Mike