Prev: charts with percentages
Next: Conditional Format
From: Michael on 21 Apr 2010 08:38
Hi, I have a lookup that is looking at 2 different worksheet and the formula
is

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

So the formula is asking if cell D1 = Ruth Baybut then lookup the value on
the ruth baybut sheet otherwise look on sheet2.

Is there a smaller and quicker formula for this please?
 | 
Pages: 1
Prev: charts with percentages
Next: Conditional Format