Data Link for output cell as a result of sumproduct..

Hi..

I am just checking a possibility of displaying corresponding data of a cell generated out of function Sumproduct with condition. e.g. my output is as under

> 5 and <= 10

Applns. Amount

2 0.15

Here, I have generated Applns as well as Amount from a data available in different sheet by using Sumproduct function with multiple condition.

Now, if user wants to check up the details of this summation e.g. 0.15, by clicking this particular cell , is there any way to display details from where it was fetched.. By this way I will restrict user to go to entire set of database and do some functions to fetch this data..(here I am also setting Protection to cell ON)..

Regards,

Kundanlal

Post a small sample file (not image) showing what you require.

Posting sample file.. Here report is generated in Output sheet where for selected product "cycle", England is showing 150.. (this worksheet is protected with password "abc" which I wanted to do in actual report). My query was is there any way to show in the sheet output only, by clicking output 150 for England, respective details from Input sheet of corresponding to England can be displayed so that user should not go to actual database.

I can't download file: remove p/w protection.

Going out for some while.

OK Sir, uploaded file samplebook2.xls..

kundanla,

Select product in C4,

Your formulae show totals by country in Cols B and C.

Attached now uses "array formula" in F6 to list all the entries that make up the totals as follows:

=IFERROR(INDEX(Input!$A$2:$D$11,SMALL(IF(Input!$C$2:$C$11=$C$4,ROW(Input!$A$2:$A$11)-1),ROW(Input!A1)),1),"")

(If no product is chosen, the cell remain blank. Otherwise it looks down Col A to find the first row where Col C matches whatever you put in C4, Then moves to next row and looks for next match, repeats in next row, and so on until it reached the end of COl A)

Formula is copied across and down, adjusting the Col Rrf at end from 1 - 4

Hope this helps

Ochimus