# How to get data out of it?

##### Board Regular

from this data:
I need to work out is....
1. if i enter Product code it search out the min price against that code in column 2 its i have done by formula MIN(IF) bla bla

2. Now the next is ... i need to have if i enter product code ...

first it get the min price against product # then show the order ref. and order date in same row...

if anyone can help with this?

AFB

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### Andrew Poulsom

##### MrExcel MVP
What formula are you using to find the MIN?

##### Board Regular
What formula are you using to find the MIN?

we entered product # in E1 n formula in F1
then
=MIN(IF(A2:A13=E1,B2:B13))
ctrl+Enter

#### Andrew Poulsom

##### MrExcel MVP
Try:

=INDEX(C2:C13,MATCH(MIN(IF(A2:A13=E1,B2:B13)),IF(A2:A13=E1,B2:B13),FALSE))

=INDEX(D2:D13,MATCH(MIN(IF(A2:A13=E1,B2:B13)),IF(A2:A13=E1,B2:B13),FALSE))

confirmed with Ctrl+Shift+Enter.

##### Board Regular

Try:

=INDEX(C2:C13,MATCH(MIN(IF(A2:A13=E1,B2:B13)),IF(A2:A13=E1,B2:B13),FALSE))

=INDEX(D2:D13,MATCH(MIN(IF(A2:A13=E1,B2:B13)),IF(A2:A13=E1,B2:B13),FALSE))

confirmed with Ctrl+Shift+Enter.

Not working.....

Too few arguments for this function.

#### Andrew Poulsom

##### MrExcel MVP
Not working.....

Too few arguments for this function.

##### Board Regular

Check this out mate, here its saying Error in value

#### Andrew Poulsom

##### MrExcel MVP
The formula works perfectly for me. Is part of the formula highlighted when you get the error?

##### Board Regular

I don't see error highlight.... if u can help with this...

AFB

#### Haseeb Avarakkan

##### Well-known Member
Hello, Try,

<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />

Replies
5
Views
160
Replies
1
Views
257
Replies
3
Views
223
Replies
2
Views
128
Replies
0
Views
252

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,982
Messages
5,834,682
Members
430,310
Latest member
Excelorate3305

### 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.

### Which adblocker are you using?

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

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