Hi

For XL 2003, you could have a more efficient formula by using

=IF(AND($D1="ruth baybutt",Countif(ruth baybut!F:F,A$3)),
HLOOKUP(A$3,ruth baybut!F:N,3,0),HLOOKUP(A$3,sheet2!F:N,3,0))

--
Regards
Roger Govier

Paul C wrote:
If you are using Excel 2007 you can use the new IFERROR function. (you dont
have to type the conditions twice)

=IFERROR(IF($D1="ruth baybutt",HLOOKUP(A$3,ruth
baybut!F:N,3,0),HLOOKUP(A$3,sheet2!F:N,3,0)),0)

If you are using 2003 the formula is about as compact as can be.

For both versions, the formula would calculate more quickly if you did not
use whole column references (F:N) and instead limited the lookup to the data
area (i.e. $F$1:$N$400)