From: Michael on
Hi, I have a lookup that is looking at 2 different worksheet and the formula

=IF(ISERROR(IF($D1="ruth baybutt",HLOOKUP(A$3,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