Index formulas replacing VLookUp Formulas
It has been recommended that I replace my vlookup formulas with Index(Collect) formulas. This is my first experience with the Index and / or Collect Match concept and honestly I am struggling on my first try. I am trying to pull in a total funds approved value from the my budget sheet to my portfolio sheet.
Both Sheets start with a column title OPS# - this would be the matching data value and I want to pull the value from the column/cell match "Total Funds Approved". The are name the same on both sheets.
English statement (to the best of my ability) building the formula in the column titled "Total Funds Approved" on the Operations Project Log. Find the matching OPS# from the Operations Project Log on the Funds Approval Log in Column titled "OPS#. If match found then pull to the Operation Project Log the value that is in the column titled "Total Funds Approved" on the Funds Approval Log to the Operations Project Log.
Looking for a little help with this learning curve.
Help Article Resources
Check out the Formula Handbook template!