Formula Help

[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

 

[Frank Kabel]

Hi
some assumptions:
- sheet A contains the IDs in column A
- sheet B contains the IDs in column B

Enter the following in cell A1 on sheet B
=IF(ISNA(MATCH(B1,'sheetA'!$A$1:$A$1000,0)),"","X")
copy this down

 

[Jerry W. Lewis]

See Help for the Match function.

Jerry