Formula Question

[woodpecker2]

I'm struggling to setup a formula that will show the Average/Min/Max values from data held on the spreadsheet.

I need to enter a Product Code in cell B2 and the results are required in cells B4:B6.

When the Product Code is entered in cell B2, I need to find the matching code on column A and from there pick up the values from cells B9:F12

The table below gives you an idea of the table format, the actual one is a great deal larger.

Can anyone point me in the right direction with this?

Book1.xls
	A	B	C	D	E	F	G
1		Product Required
2		B
3
4	Average	3
5	Max	5
6	Min	1
7
8	Product
9	A	10	20	10	15	35
10	B	1	2	3	4	5
11	C	2	4	6	8	10
12	D	5		25		56
Sheet1

 

[ossuary]

If you are trying to use the HTML poster, take out the "code" tags from either end, and just paste the HTML directly into your message.

If that HTML code is what you actually want us to look at, you're going to need to format it better so we can read it.