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 Yes, as the previous commenter mentioned, there are many options to accomplish your objective. The new Dynamic Array formulas are amazing. Here an example formula available in Office 365 which returns the array of details you mentioned in a horizontal or vertical fashion.
This one in particular will return the name, price & bundle in a vertical layout. To use a horizontal layout, just erase the "Transpose(" and the final ")".
=TRANSPOSE(VSTACK(Table1[#Headers],FILTER(Table1,(Table1[Item'#]=Sheet3!B1))))