woodpecker2
New Member
- Joined
- Aug 2, 2007
- Messages
- 33
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?
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 |