Return next matching value

[chunhoj1717]

Hi everyone, I am struggled with finding a way to solve the below problem: 

1	A	Burger
2	A	Cheese
3	A	Fries
4	A	Coke
5	B	Nando's
6	B	Sprite
7	A	Steak

• Let say we have 5 A and 2 B formatted in this order.
• I wanted to build a formula that returns me the value Burger and Nando's in column C by searching for 1st A and 1st B in column B. Then it will continue to locate the next A (or C, D, E). 
• Is it not enough just using IF, AND, VLOOKUP formula to create this logic? Or programming a VBA for this would be required? 

[#2]

Check out the FILTER function.

[#3]

@chunhoj1717 

Couldn't get it out of my head and keep going since I've seen the problem

... it was so easy, hard ... for me :)).
I got this VBA code for the dropdown menu from the Internet,

I just don't know from where or whether I put it together, otherwise I would have liked to put the link at, unfortunately ... I'm getting old :) Everything else is manual work.

You can find an example in the inserted file.

Hope this approach helps you ... because I don't have another one :).

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.