Hi,
I've tried creating a formula that will return the value "14" if true or "4"
if false but i can't get in to work.

*=IF([B23177Takeoff.xls]H23177!$A$1:$A$3=A1,"14","4"). I'm compare two
separate spread sheets and the formula is in Book1 C1, C2, etc. When in
enter C1 the it returns the correct infromation, but once I enter in C2 it's
incorrect.

Book1 B23177Takeoff
A B C A B C
1 200 14 1 200
2 201 4 2 202
3 203 4 3 205

Any help would be much appreciated. MicheleP