You say it is part of a MATCH function - can you post a copy of the complete
formula that you are using?

Pete

"PeteJ" wrote in message
...
Hello, maybe someone can see something obvious here.

I've got the following compare as part of a MATCH function, and it always
returns false. It doesn't seem to be stepping past the first row of the
column A. I am entering this as an array formula (ctrl-shift-enter). How
come
it's not going past the first row?

{=('[File1.xls]SW'!A2:A100=A2)}

I get the same behavior using

{=('[File1.xls]SW'!$A:$A=A2)}

There is definately a value in column A that matches A2 of this sheet. It
works with a VLOOKUP.

Thanks,

- Pete