Okay, so my title is probably as confusing to you as this quandary is to me.
I have two tables, simplified for clarity. *See Attached Image* My full table 1 is 700 rows tall, and table two is 22 columns wide.
Tables.jpg
What I am looking to do is take data from Table #1 and display it in Table #2 in the "REF. WK" column based on the user associated with that row. If "REF. WK" equals 'Week 2' then I want the values 0,27,0 to display for the corresponding User reference.
The only thing I can think to do is a VLOOKUP or an INDEX, but I can't quite seem to figure out how to tell my formula to display data based on what REF. WK I choose. A simple VLOOKUP or INDEX won't work, I believe, since it requires a static column row number (rather than reference).
I've heard of a Structured Reference and Indirect Reference, but I am clueless how to use them - would either of those work for this problem that I have? Or does anyone have any other ideas as to how I could accomplish this variable display?
Bookmarks