Hi Biff,

Thank you very much for both alternatives - great! Very much appreciated.

Biff wrote:
Assume that column 7 of ACTUAL is in column G, G2:Gn
FORECAST is in column H, H2:Hn
=IF(OR(G2="",H2=""),"",IF(ROUND(H2,0)=G2,"Yes","" ))

Copy down to enough rows to allow for future addition of data in the named ranges.

Now, here's that same formula using the range names:
=IF(OR(INDEX(Actual,ROW(1:1),7)="",INDEX(Forecast ,ROW(1:1))=""),"",IF(ROUND(INDEX(Forecast,ROW(1:1) ),0)=INDEX(Actual,ROW(1:1),7),"Yes",""))

Cheers,
Sam


--
Message posted via http://www.officekb.com