Formulas

S

Simon

I have 2 spreadsheets called A & B.
I have a list of scheme id's in spreadsheet B and I want
it to look in spreadsheet A for the scheme id. If it
finds the scheme id in spreadsheet A then I want it to
leave a 'Yes' or an indicator in column A.

Is this possible? Can anyone help?

Thanks
 
Top