Forum Discussion
Quote sheet referring to price list
Hello. I am trying to make a quote sheet. We have 300 products. I was hoping there was a way to autofill my quote sheet with Name, Price, Bundle Qty using some sort of reference tool. So what I e...
RoseH915 That's done with one of several lookup functions available in Excel, depending on your version. VLOOKUP or INDEX combined with MATCH work in older versions. XLOOKUP works in the most recent versions of Excel (MS365 and 2021).
Thank you for your help! Worked like a charm. Riny_van_Eekelen
