0
=if(C15=0,(B14+(VLOOKUP(C16,,'Locks and Readers per day'!D:E, 2, false))),(B15+(VLOOKUP(C16,'Locks and Readers per day'!D:E, 2,FALSE))))

What am I doing wrong?

  • You have an extra , in the first vlookup. – Scott Craner Aug 17 '18 at 15:48
  • 1
    BTW it can be simplified to: =IF(C15=0,B14,B15) +VLOOKUP(C16,'Locks and Readers per day'!D:E, 2, FALSE) – Scott Craner Aug 17 '18 at 15:50
1

There is a comma to much :

=if(C15=0,(B14+(VLOOKUP(C16,'Locks and Readers per day'!D:E, 2, false))),(B15+(VLOOKUP(C16,'Locks and Readers per day'!D:E, 2,FALSE))))

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.