Hi Mark,

Welcome to ExcelFox community.

Don't understand what you intend to achieve. If you take out ,'09 Data'!E:E,"6262" from the formula you have already used, wouldn't it give for all values of column E (ie, 6262,6270,6277)