vlookup help

[samantha]

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.

 

[Pete_UK]

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