Hi
Apologies if this has been posted before somewhere..
I have a spreadsheet, which has users details on it, plus a list of applications they have in the form of 2 dimensional matrix (apps across the top, and an 'X' marking off whether they have the app). If I wanted to pull out a user, plus a list of their apps on a separate spreadsheet, how would I do this.? I see there is a VLOOKUP you can use with MATCH to look at the data from both dimensions, but I want something in reverse really, i.e. type in a user id, and for it to list the applications beneath.
I suppose the alternate query for this, is to ask how you would create a flat table from the matrix as described above. Instead of having:
User App1 App2 App3
xx999 X X
I'd like:
xx999, App1
xx999, App3
and so on
Hope that describes this weird query. If anyone can help let me know.
John
Bookmarks