Nesting Formulas. Address? Return cell next to?

Hi,
I have a work book with 2 tabs.

The second tab contains a large (growing) data set.
A=Group (property description i.e.Solid, Gas, House, 1 bed)
B=URN (unique, letters and numbers)
D=SAP score (Numeric value, not unique)
E onwards show other data relating to this URN

I want the first tab to summaries these results by showing the minimum, maximum and average for each group.
B=Group
E= needs to show the URN of F below
F=needs to show min max SAP scores for the group
E onwards, needs to show other data relating to the URN

I have used this formula in Column F on the 1st tab to return the minimum score within the group:
{=MIN(IF(Fulldataset!$A$3:$A$187=MinMaxAve!B4,Fulldataset!$D$3:$D$187))}

I can not then use this to look up the URN or the other data needed as the SAP score is not unique.

Ideally I would like to use the above formula in column E on the first tab (URN) and add to it so it finds the minimum in column D on the second tab but returns the value in the cell 2 to the left (column B on the second tab) on the same row. Is this possible?

I have also tried using CELL("address"... and ROW... before the above formula but these returned errors when used with the formula.

Any suggestions and help you can offer would be appreciated.

Many thanks.