Formula Help

  • Thread starter Thread starter Simon
  • Start date Start date
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
 
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
 
Back
Top