I am looking for a formula that will return multiple records if criteria met. Vlookup only gives me the first occurrence.
The blue table has all the data. J2 is where I enter criteria and Green table is my desired output. Thanks for your help!
I am looking for a formula that will return multiple records if criteria met. Vlookup only gives me the first occurrence.
The blue table has all the data. J2 is where I enter criteria and Green table is my desired output. Thanks for your help!
Hi Kerah,
You need to learn the Advanced Filter tool built into Excel. Search for it online to see what it does to solve your problem. I've added some spice to your problem by making the J2 cell a dropdown of names and then doing a VBA (recorded macro) to advance filter your table based on that name. Simply change the name in J2 and watch it work. Hope this motivates you to learn Advanced Filters.
Advanced Filter from Change Event Dropdown.xlsm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for the extra spice Marvin. The reason I was looking for a formula is because I need output to change dynamically. Users will change criteria on a daily basis.......
A formula that will return the results seen in columns I:K is:Formula:Please Login or Register to view this content.
Paste the formula into cell I5, drag the fill handle over to cell K5 and then, while I5:K5 are still selected, drag the fill handle down to cell K7.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Cell I5 formula
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks