Help with formula

[Glenn]

Hi,

I hope you can help me with this formula.

I have two spreadsheets called the following:-
1) SME main 200410
2) SME PRE accounts CAT1_RCB checked 120310 (2)

Coloumn A in both spreadsheets contains a list of numbers (e.g.
1012381211420) and both coloumns contain 6905 rows.

I need a formula in cell b1 of spreadsheet 2 that will look at the number in
cell a1 of spreadsheet 2 and if that number is in coloumn A of spreadsheet 1
then I want cell b1 of spreadsheet 2 to return a value of Yes if not then I
want a value of No

Thanls

 

[Pete_UK]

It's easier to set this up with both files open at the same time. Put
this formula in B1 of your second file:

=IF(ISNA(MATCH(A1,'[SME main 200410.xls]Sheet1'!A:A,0)),"no","Yes")

Then you can copy this down column B. You can then close the first
file, and the formula will expand to include the full path to that
file.

Hope this helps.

Pete

 

[Vince Bernhardt]

One other possible solution would be to use the following formula

=IF(ISNA(VLOOKUP(A1,'[SME main 200410.xls]Sheet1'!A:A,
1,0)),"no","Yes")