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

​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). INVOICEPRICELIST TABLE I am hoping this is something simple I can do with INDEX or MATCH vs. using modeling. Does anyone have any ideas? Thanks    Read More

​