Forum Discussion
best way of returning data from a table
Hi I have a worksheet showing a materials list column headers include Job Type, Item number, description, purchase cost, quantity, price, vat Would like to be able to have a separate worksheet wher...
Could you give us an idea of what the two sheets look like, by attaching screenshots, or a sanitized copy of the workbook without sensitive data?
Does this do what you want?
=LET(filtered, FILTER('Material List Original'!A2:I1000, ('Material List Original'!A2:A1000=B1)+('Material List Original'!B2:B1000=B1)+('Materials List Original'!C2:C1000=B1), ""), IF(filtered="", "", filtered))