Hi,

In column A of sheet 1 (say cell A2), you could use
=if(countif(Sheet2!$C$2:$C$500,B2)=1,"Hold","Rele ase")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"samantha" wrote in message
...
Hello,

this is my scenario On sheet 1 i have a list of values in colum B that
represent account numbers, if the account number in Column B Sheet 1
appears
in the list of hold accounts on Sheet two, i want to return a value of
'Hold"
in column A of sheet 1. I can't seem to get the syntax or formual
correct.
Any help would be greatly appreciated, if i can't get the formual to work
i
will have to match it all manually and with 1200 l ines of data that is
going
to hurt.

Thanks!!!!