vloolup or other, how to make statement values by keywords?

Hello guys,

I wonder if you could help me to solve this task, which could save my time to drink tea?)
Attaching list.Untitled.jpg

Thank You,
Akmal

Hi,

Not sure what you mean by make it automatic.

This formula should work for you.

Please Login or Register  to view this content.

Enjoy your tea!

Cheers

.
Here's a macro. Copy and paste into a Routine Module, activated with a Command Button:

Please Login or Register  to view this content.

Thank You Southward, that really works.

i tried macro, but it sorted by companies, as Pivot Table, anyway thank you!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Understood.

You are very welcome. Glad I could be of some assistance.

Cheers