dmthornton, Narayan,
Thank you so much! It never occurred to me to use a VLOOKUP for this. Classic rookie mistake paired with frustration. Your formula works perfectly! I had tried INDEX, OFFSET, even tried making Data a table, all to no avail. Guess I need to spend even more time on this...
Hello all,
I've been messing around with the "Simple KPI Dashboard" here on the website, and I think I've reached the point where my vision outpaces my skill.
I have the Financial, Internal Process, and Sales tabs set up so that they ALWAYS reference Column F and Column G (these will be...