The attached document has a "Current Portfolio" column (here column R) that can change. At the bottom of the sheet (rows 1761-1766), in that column, there are some labels I'm hoping to use for an INDEX/MATCH, VLOOKUP type formula. The formula itself will be on another sheet (on the attached, Sheet2!B8 for example.
What I'm wondering is how to use INDEX/MATCH or VLOOKUP, with the array beginning in the column where i find "Current Portfolio" (in this case, again, column R). I can't seem to wrap my head around how this should be done. One more note is that row 7 are cell references and should be dynamic (should be able to change those references around, plugging in different numbers and row 8-9 should adjust accordingly). Thanks!