Lets say I have a table with data. I want to create a sub table that picks rows from the source table depending upon criteria.
What is the best way to create the sub table (so that it does not have empty lines in between, if we were to follow a brute force method of creating)
thanks
| +270 | Why UBS Is the Worst Place to Start Your IB Career | 41 | 2h |
| +220 | UBS 2nd Year Analyst Q&A (2026) | 41 | 1d |
| +131 | UBS IB 26Q2 a Disaster! Advisory Revenue Down 23%, Capital MarketsDown 5% | 19 | 32m |
| +104 | What's your craziest "hardo" story? | 18 | 14h |
| +77 | Downfall of Qatalyst | 18 | 12m |
| +58 | Lincoln International Return Offers | 20 | 5m |
| +56 | Wolf of Wall Street vs. Reality: Anyone else feel scammed by the movies? | 19 | 1d |
| +55 | Elite Boutique interview questions | 17 | 2d |
| +50 | Suspended for a Year | 21 | 1d |
| +43 | so confused about 28 SA timeline | 30 | 23h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
vlookup
or h-look up if you're nasty
Guess, I am a bit lost - Well Lets say a table is:
A Q1 2005 B Q2 2005 C Q1 2005 D Q4 2005
Now I want to create a table with only Q1's so that it is only two rows: A Q1 2005 C Q1 2005
How do I use VLOOKUP for this? Appreciate it
if it's in order so that Q1 rows repeat every 5 lines use the offset function
Im sure there's a function to do what you need, such as the above mentioned ones, but a pretty simple macro would also do the trick.
VLOOKUP is your answer. Are you really too lazy to Google that?
you could make a pivot table too
pivot table would work, but for this VLOOKUP works great...i actually have the VBA book sitting in front of me :)
=SUMPRODUCT(($A$1:$A$4=$A10)($B$1:$B$4=$B10)C10)
This assumes your new table starts in row 10 and the combinations in columns A and B are unique.
Or you can concatenate columns A and B, then use vlookup.
Inventore aut in harum fuga. Quam dolores quia sequi temporibus quia totam exercitationem. A repudiandae porro quibusdam. Quaerat dolore autem fugiat pariatur similique iste.
Ipsum et rerum molestiae consequatur rerum id in id. Rerum voluptatem beatae veniam quidem accusamus rerum fuga ea. Expedita voluptate hic facilis sed corrupti. Error fuga omnis doloremque qui et fugit animi.
Non sint voluptas et velit est. Non in eveniet qui animi ut veniam consectetur. Voluptatem nostrum ipsa sint sint maxime dolorem sit. Illo debitis omnis aut corporis inventore laborum. Nobis consectetur possimus nesciunt ratione.
Odio vero amet quas error et quidem. Saepe qui molestias nesciunt. Nulla error exercitationem aliquid repellat ut officia asperiores.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...