You're welcome. Thanks for the feedback!

Biff

"Sam via OfficeKB.com" wrote in message
...
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(Forecas t,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