New problem - probably a simple answer!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the formula I am using - nice simple lookup

C2 =LOOKUP(B2,Sheet3!A:A,Sheet3!C:C

Now... in C3, if it cannot find B3 in Sheet3!A:A, rather than showing zero it simply returns the value of B2 - why

Thanks in advance!
 
Back
Top