Hello there,
I've got a worksheet where each row has a drop-box input with the values "material ordered", "in progress" and "at subcontractors". What I aim to do is have, on another worksheet in the same document, a table which lists all the "works order numbers" (Cell range A:A) that are currently in the "material ordered" state, "job in progress" etc.
So, for example - I would enter data into Row A, sheet 1, mark it as "material ordered", and as soon as I have done so, the cell-value from A1 would pop up under the "material ordered" column in Sheet 2. I attempted to do this with INDEX-MATCH, which somewhat worked - the problem being that there were large gaps in the list, as the INDEX-MATCH would only show the values in their corresponding rows, meaning that the table on sheet 2 would have to be as long as that in sheet 1, which defeats the purpose.
Would this be possible?
Thanks in Advance for the help
(I have attached the worksheet I am working on, The data will be entered in "schedule", the drop-down values are in the column marked "progress" the value i want displayed is W.O.N and the Data is to be displayed int the columns at the bottom of the "SEARCH" sheet)
Bookmarks