Extract matching data in nest sheet

[jayanta1978]

Dear Friends

Please do solve the problem i am facing to get the exact data


If any amount (in decimal) is put against any customer in RPS column it will automatically featch the Customer Name , Area , Campaing , Amount spend and finally total amount in "Sheet 2"

[shukla.ankur281190]

Try

C3=IFERROR(INDEX(Sheet1!$B$4:$R$14,SMALL(IF((Sheet1!$B$4:$B$14<1)*(Sheet1!$B$4:$B$14<>""),ROW(Sheet1!$B$4:$B$14)-ROW(Sheet1!$B$3)),ROWS(A$1:A1)),MATCH(C$2,Sheet1!$B$3:$R$3,0)),"") with control+Shift+Enter and drag down!!!