I need to build a sheet based on an approval matrix per function/dep code and differents amounts.
I figured out how to pull data from a cell using Index Match formula to bring the Approver on my target sheet based on the cell "Function/dep code" but now I need to bring the approver based on the amount input in column PO amount. Depending on the amount it would need approval from different people.
I tried using index collect but I kindly ask for help as I do not know how to build it
Help Article Resources
Check out the Formula Handbook template!