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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match function problem 3
SUMPRODUCT 7
Sumproduct in matrix means 3
How to return and sum up multiple values 5
Show formula result in another sheet 1
Need formula to return exact match 8
How to maintain references when copying lookup formula 2
Excel Help to copy information from one row at a time to another sheet 1

Back
Top