Hello!
I have two sheets (Titles and Accounts).
The Accounts sheet has two columns: Participant Name (column A) and PRODUCT_ID (column B).
The Titles sheet has 32 columns, but the only one that matters is PRODUCT_ID (column AF).
In the Accounts sheet, multiple participants can have the same product ID.
In the Titles sheet, multiple titles can have the same product ID.
I'm trying to find a way to search to pull in the multiple participant names that match each product ID and the only way I think of is a VLOOKUP (though I'm open to other suggestions).
Please let me know if I need to clarify anything.
If it helps, I work in publishing, so think of it in terms of customer A bought a Science bundle and a History bundle. Customer B only bought a Science bundle. Each bundle has multiple books in it. How can I find out how many titles customer A has and how many customer B has?
Thank you in advance. I have been searching and trying different ideas for hours and would so appreciate some help from someone with more knowledge than me
I have two sheets (Titles and Accounts).
The Accounts sheet has two columns: Participant Name (column A) and PRODUCT_ID (column B).
The Titles sheet has 32 columns, but the only one that matters is PRODUCT_ID (column AF).
In the Accounts sheet, multiple participants can have the same product ID.
In the Titles sheet, multiple titles can have the same product ID.
I'm trying to find a way to search to pull in the multiple participant names that match each product ID and the only way I think of is a VLOOKUP (though I'm open to other suggestions).
Please let me know if I need to clarify anything.
If it helps, I work in publishing, so think of it in terms of customer A bought a Science bundle and a History bundle. Customer B only bought a Science bundle. Each bundle has multiple books in it. How can I find out how many titles customer A has and how many customer B has?
Thank you in advance. I have been searching and trying different ideas for hours and would so appreciate some help from someone with more knowledge than me