# Lookups with Min and Max values

#### hayfish78

##### New Member
Hello,

Looking for some help, I have large set of numbers and Im trying to pull information from to create a help / crib sheet.

Column M is the reference number and im looking for a formula for Column J and L to provide the Min and Max Numbers associated Colum M based on the values in Column F and G,

I have manually inserted the min / max values for Column M value 0 to show what im looking for, so 0 is equal to a min value of 0 and a max of 0.5, 1 has a min value of 1.6 and max 2.4

Any help gratefully appreciated as im struggling to come up with something

#### Attachments

• Untitled.png
20.5 KB · Views: 7

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Fluff

##### MrExcel MVP, Moderator
Hi & welcome to MrExcel.
You can use the MINIFS & MAXIFS functions to do that.

#### hayfish78

##### New Member
Hi & welcome to MrExcel.
You can use the MINIFS & MAXIFS functions to do that.
Hello

Ive tried to create something using the min and maxifs statements but struggling to understand the criteria to be honest

#### Fluff

##### MrExcel MVP, Moderator
In that case can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

#### hayfish78

##### New Member
its ok ive now sussed it out - thanks

#### Fluff

##### MrExcel MVP, Moderator
Glad you sorted it & thanks for the feedback.

Replies
2
Views
343
Replies
12
Views
323
Replies
0
Views
179
Replies
1
Views
1K
Replies
2
Views
68

1,147,455
Messages
5,741,218
Members
423,649
Latest member
steel1968

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