I'm working in Excel 2007 and having some issues doing what I need to do.
I have a speadsheet that has a list of users in column A. A list of applications that these users are using runs across row 1. If a user has a lisence for an application there is an 'x' placed at the intersection of the row and column.
I didn't set up this spreadsheet, so I can't really change the basic layout. But I've been tasked to create a space in the worksheet that would allow my manager to pull a report showing the names of users for a specific application.
I've played around with pivot tables, vlookups, hlookups, countifs, all sorts of random methods to get this moving, but cannot seem to figure out how to get it going.
Basically I've created a dropdown list for the application names. I would like for my boss to select the application she would like to see the report for and then have it be automated from there. Search across the row 1, then down through the correct column, if an 'x' is in that column, then return the information in column A.
It sounds so simple to me, but I'm just blanking today.
