INDEX & Match
I have what I am calling a 'Lookup' Worksheet.
I also have a Change Order Log, an Invoice Log and a Contract Log.
I would like the 'Lookup' worksheet to return all Change Order(s) info, Invoice(s) info and Contract info.
Column 'PC #' is hidden and each of the columns to the right of 'PC #' contain Index & match functions.
Currently this works PERFECTLY when there is only 1 Change Order, or 1 Invoice.
How do I get the 'Lookup' worksheet to pull all the Change Order info (if more than 1 Change Order) and all the Invoice info (if more than 1 Invoice).
Help Article Resources
Check out the Formula Handbook template!