filter or pivot style by formula

[arctushar]

Hi
I have attached an excel file. Here "Specification" is the main data entry sheet. Now I want that in temporary sheet of the attached file Store Report Buildtrade.xlsx . I will input only the Challan number in green background cell. The date of of the challan will be automatically, I can do that. But I want that
Automatically it will pull data from specification sheet that challan number is as my givven challan number on sheet temporary. for example here I have input challan number 27009, and corresponding values r below. How can I do that ?
thanks

[:) Sixthsense :)]

In J1 Cell

Please Login or Register  to view this content.

In A4 Cell - Array Formula Requires CTRL+SHIFT+ENTER

Please Login or Register  to view this content.

Drag it down....

In B4 Cell - Array Formula Requires CTRL+SHIFT+ENTER

Please Login or Register  to view this content.

Drag it down and right....

Refer the attached file for details.