Invoice population from different worksheet

Copper Contributor

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). 





I am hoping this is something simple I can do with INDEX or MATCH vs. using modeling. Does anyone have any ideas? Thanks



1 Reply

@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.