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...
Let's say Job Type is column A on a sheet named Materials List, and headers in A1:G1.
On the other sheet, enter the text "Job Type" in A1, and use B1 to enter the job type you want to display.
Copy A1:G1 from Materials List to A3:G3 on the other sheet.
Enter the following formula in A4:
=FILTER('Materials List'!A2:G1000, 'Materials List'!A2:A1000=B1, "")
Thank you Hans, I'll try that shortly
Just come across another issue in that an item might relate to more than one job type. If you were to have more than one Job Type column would you use an IF function?
For example; IF A1 contains JOB then return data - IF A1 is blank look to B1... and so on