I have two tables:
Table#1 is Store Name, Date, Hours.
Table#2 is Store Name, Date, Sales.

Need to merge the two based on Name and Date, but there are entries on Table#2 that doesn't exist in Table#1 due to Store not open that day, but a sale was posted to that Store while the Store is closed.
How can I incorporate a formula to merge the Sales number from Table#2 to the last occurrence of Store Name based on the entry Date?

  • 1
    Welcome to Web App Stack Exchange! Can you share a copy of your spreadsheet, with all sensitive information removed?
    – David Tan
    Jul 1, 2022 at 5:02
  • @DavidTan Adding the google sheet as suggested: docs.google.com/spreadsheets/d/…
    – Andrew
    Jul 4, 2022 at 14:27
  • Hello @Andrew, can you check the test result tab? If this is close enough to what you want to happen, please do let me know so that I can document my answer. I'm rather unsure whether this is want you want to happen.
    – David Tan
    Jul 6, 2022 at 5:14
  • Hi @DavidTan, thanks for the attempt. It looks like it is missing a few of the sales that didn't have a matching date with hours. I'm not sure if it is even possible to capture those to embed into the table.
    – Andrew
    Jul 11, 2022 at 14:00


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.