Assuming your list of constants is in column A on the master sheet,
put this in A1 of sheet1:

=IF(ISNA(MATCH(B1,Sheet2!A:A,0)),"","hold")

Then copy this down as far as you need to.

Hope this helps.

Pete

On Sep 12, 1:03*am, samantha
wrote:
Hello,

I am having trouble creating a formula with vlookup. *On page 1 i have a
list of changing values and on page two i have the list of constants, what i
am trying to do is in the first page if a value in column B is on the master
list in page 2, to give a value of hold in column A. *I can't seem to get the
sytax of the formula correct. *Any help would be appreciated.