Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
Guys, I come again to you with a question for the ages and it has to do with VLOOKUP/HLOOKUP
I never really learned how (or understood why) H/VLOOKUP works and I think it might be relevant for my problem.
I have an Excel sheet that implements a SQL query and dumps the 3 columns I'm looking for into a worksheet. That's easy. Here's a screenshot (important secret info hidden, but consider it a unique identifier):
So when I hit refresh (F5) the query runs and gives me this. I know how to make a pivot table, but only basically. What I want to do is have something look at the State (first column) and match it to a name here:
This list changes once a month and any manager might be assigned a different state to work, but this is largely a static list.
The results of the subtotaling/counting should populate in the yellow columns on this other worksheet:
For all intents and purposes, consider each column displayed here in each image "A" and each row as "1"