PLACE THIS FORMULA INTO COLUNM D

=IF(A1=C1,B1,"")

Once you have placed it into the first Dcell just copy it down for al
values

the cell ref should just change automactly.

What it is say is if the contents of cell a1 are equal to c1 the cop
b1 into d1. If this is not true then leave contents of cell d1 blank.

you should be able to cange this for differ things

ie < is less then
is more then

<= less then or equal
= greater or equal
= eqa

--
Message posted from http://www.ExcelForum.com