# Lookup address of a number

#### tony0682

##### Board Regular
Is there a way to get the cell address of where the min and max is?
Book5
ABCDEFG
145.953624.5373793.7610180.87473Min2.790352
313.2374663.915262.5981755.8505
427.9528369.1919972.2219981.1749Max98.85546
646.2998882.9054832.9885887.23957
787.4556668.4199713.3619176.73568
894.2917936.1920743.933639.164768
93.42007240.7521276.674433.850973
1050.1727616.9492898.8554647.3043
1151.8089539.386977.1363635.26832
128.0263760.3358898.124262.790352
1377.5022881.2755331.3347698.29505
Sheet1

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Edit: Deleted.

#### Domenic

##### MrExcel MVP
Try the following formulas which needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER...

G2:

or

G5:

#### Domenic

##### MrExcel MVP
Note that if the target value is found in both A10 and C5, my formula will return the topmost address, C5, whereas pgc01's formula will incorrectly return A5...

#### tony0682

##### Board Regular
Worked great. Thanks.

#### pgc01

##### MrExcel MVP
Hi tony0682

I hope you have read Domenic's last post. My formula may give a wrong result in case of duplicate numbers. I have erased it.

Thank you Domenic for pointing out the error.

Replies
7
Views
204
Replies
3
Views
222
Replies
3
Views
276
Replies
2
Views
605
Replies
7
Views
456

1,171,586
Messages
5,876,318
Members
433,193
Latest member

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