Formula Question

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?
Book1.xls
ABCDEFG
1Product Required
2B
3
4Average3
5Max5
6Min1
7
8Product
9A1020101535
10B12345
11C246810
12D52556
Sheet1
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

ossuary

Active Member
Joined
Sep 5, 2004
Messages
279
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. :)
 

Forum statistics

Threads
1,181,405
Messages
5,929,756
Members
436,687
Latest member
Glass of Gin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top