Hi All,

I have two Dynamic Ranges: "ACTUAL" spans 7 Columns and many Rows. "FORECAST"
is one Column and many Rows.

I would like to check if the numeric values in the LAST Column of "ACTUAL"
match the values in "FORECAST" on the same Row. If there is a match on the
same Row, I would like a text string of "yes" returned; blank if no match.

The numeric values in "ACTUAL" are all integers. However, the numeric values
in "FORECAST" are a mix of integers and numbers to five decimal places.

So, if the LAST Column of "ACTUAL" has a value of 61 and the corresponding
Row in "FORECAST" has a value of 61.33333 then, this should be taken as a
match. However, if the value in "FORECAST" is 61.66667 then, this is viewed
as 62 and is NOT a match with 61.

Thanks
Sam


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