I have a powerpivot file working with 10 tables.

One table is OPT is have  40 fields, including CUST_CODE and DATE.

I one Excel sheet i would like to create a lookup.

Basically in Cell A1, I enter one CUST_CODE,  in Cell A2, I enter one DATE, or range of DATE

I would like to display all the records corresponding to this filter but with only 6 fields among the 40

Absolutely dont know how to do it

Hi sharkantipav

Since you are working with powerpivot, you have to work with pivot table only. Basically you have to create pivot table in new worksheet and choose your desired field. Place all your six fields in filter area of your pivot table.

Thats All, You don't have to need any Measure for the same.

Thanks & Regards,

CMA Vishal Srivastava

Hi sharkantipav

Since you are working with powerpivot, you have to work with pivot table only. Basically you have to create pivot table in new worksheet and choose your desired field. Place all your six fields in filter area of your pivot table.

Thats All, You don't have to need any Measure for the same.

Thanks & Regards,

CMA Vishal Srivastava