Need help here: SELECTING AND PULLING ALL DATA FOR THE GIVEN CRITERIAS

[Lifecoachlee]

Hi everyone,

I need some help here.

Here's my table.

Search by: Month	Monthlist
Date	Dealer	Pickup Site	Product	Qty	Result1	Result2
12-Apr-14 13-Apr-14 15-Apr-14 27-May-14 30-May-14 30-May-14 31-May-14 <colgroup><col></colgroup><tbody> </tbody>	ACAPARROS CALOSUY AMSERCO ASIATIC ACAPARROS ASMART ASMKTG <colgroup><col></colgroup><tbody> </tbody>	EX-PASIG EX-PASIG FOB MILL EX-PASIG EX-PASIG EX-PASIG EX-PASIG <colgroup><col></colgroup><tbody> </tbody>	L.LAPU L.LAPU ELEF. L.LAPU ELEF. ELEF. G.HARV. <colgroup><col></colgroup><tbody> </tbody>	300 200 500 700 1500 1500 1500 <colgroup><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

Here's what I wanted to happen.

I have a data validation for month where I can select which month I wanted to generate the result.
I wanted all values in QTY columns to be placed in RESULT1 column for the month of MAY and EX-PASIG and all DEALERS in RESULT2 column.

I hope my explanation is clear.

Thank you in advance and God bless!

 

[Aladin Akyurek]

It's not clear which actual values must appear under the headings Result1 and Result2...

 

[Lifecoachlee]

It's not clear which actual values must appear under the headings Result1 and Result2...

Sorry about that. Example: If the selected month is MAY, QTY values should appear under Result1 for the selected month (MAY) DEALERS values should appear under Result2 for the selected month(MAY)

 

[Aladin Akyurek]

Sorry about that. Example: If the selected month is MAY, QTY values should appear under Result1 for the selected month (MAY) DEALERS values should appear under Result2 for the selected month(MAY)

Which actual values?

 

[Lifecoachlee]

Which actual values?

Hi Aladin,

Sorry for the confusion. You can forget about this.
I have another thread here - http://www.mrexcel.com/forum/excel-questions/779022-display-all-values-same-date-vertically.html
Please help me. Thanks.

 

[Aladin Akyurek]

Hi Aladin,

Sorry for the confusion. You can forget about this.
I have another thread here - http://www.mrexcel.com/forum/excel-questions/779022-display-all-values-same-date-vertically.html
Please help me. Thanks.

I don't see why another was needed. Anyway see:
http://www.mrexcel.com/forum/excel-questions/779022-display-all-values-same-date-vertically.html