I have a user interface , then a list of =unique() functions populating an inventory list. Finally, multiple instances of an ingredient are summed up into a concise list. A final list of vlookups, for cost, sometimes fails. It tries to lookup "" (nothing) instead of the ingredient in the final list. It's calculation seems to be just firing too early.

I suppose I will just keep on trying different ways to accomplish this task until something works reliably?

p.s. the first item in this list has a fixed value at $0.05. None of the cost functions will populate until I refresh them. They seem to last for a couple hours.

enter image description here

  • Welcome to Web Applications. Is this question about Google Sheets? I so, please use google-sheets instead of google. By the other hand, what do you mean by "I have a user interface"? Also, please show the formulas that you are using and add a a link to a demo spreadsheet shared it with anyone with the link to view only.
    – Rubén
    Jul 11 '21 at 1:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.