Populating the sheets with data from another sheet when criteria is met

[Lifecoachlee]

Hi everyone,I need some help here.

Here's my table.

COLUMN A	COLUMN B	COLUMN C
DEALER CODE	LOCATION	RESULT
ASMART PBAKEXMILL ACAPARROS ASMKTG AMSERCO ASIATIC H-IIXMILL CSC CALOSUY DAETSLK EGSMDSE	ARIAS WHSE ARIAS WHSE METRO MANILA ARIAS WHSE PROVINCE ARIAS WHSE ARIAS WHSE METRO MANILA ARIAS WHSE PROVINCE PROVINCE

<tbody>
</tbody>

Is there any formula in excel where you can populate the cells in Column C all dealers which are from Metro Manila and Province?


Thank you for the help.


Many thanks,
Lee

 

[Lifecoachlee]

Thank you everyone! I am starting to love excel...
Sorry to bug you all. I just a starter here in excel and working on a project.
You guys are great! Blessings!

 

[Aladin Akyurek]

Thank you everyone! I am starting to love excel...
Sorry to bug you all. I just a starter here in excel and working on a project.
You guys are great! Blessings!

You are welcome. Bugging? It's more often than not the other way around...

 

[markmzz]

Thank you everyone! I am starting to love excel...
Sorry to bug you all. I just a starter here in excel and working on a project.
You guys are great! Blessings!

You are welcome and I'm happy that your problem was solved.

Until the next.

Markmzz