Jun 12 2024 12:33 AM
I have an invoice in excel that I want to be able to enter the qty and the item number and have it populate the description, type, unit price and line total (the discount must be added manually bases on specific client parameters).
INVOICE
PRICELIST TABLE
I am hoping this is something simple I can do with INDEX or MATCH vs. using modeling. Does anyone have any ideas? Thanks
Jun 12 2024 12:54 AM
@AKSummer907 Please see the attached file. It contains a basic example demonstrating XLOOKUP and VLOOKUP in case your Excel version doesn't support the first function.