# Lowest value in range of data

#### slimimi

##### Well-known Member
Hello there.
I am trying to place a formula in Cell "S5" that will look at sheet "audusd" in the entire Column D and return the Highest value.

Can anyone help plzzz?

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### DonkeyOte

##### MrExcel MVP
either of MAX(audusd!d:d) or LARGE(audusd!D:D,1) should work for you

Try this :

=MAX(D:D)

#### slimimi

##### Well-known Member
thats great thanks.
But i need the formula to look at a different sheet, say for example, "audusd" in column D. Is that possible?

#### Richard Schollar

##### MrExcel MVP
Did you look at lasw10's answer?

#### slimimi

##### Well-known Member
so sorry. thank you guys. thanks lasw10. I was Trying to do too many things at the same time

#### slimimi

##### Well-known Member
do you mind if i take that 1 step further. is it possible to add a substitute function into that formula for the sheet name? for example :

look in cell A5 (which will be "AUD/USD"

now (same formula) but instead of looking at sheet "audusd" we look for sheet based on cell value from Cell A5 but substituting the "/" for a "" ?

#### DonkeyOte

##### MrExcel MVP
=max(indirect(substitute(a5,"/","")&"!d:d"))

#### slimimi

##### Well-known Member
wow - thanks so much...

#### Peter_SSs

##### MrExcel MVP, Moderator
I am trying to place a formula ... that will look ... in the entire Column D and return the Highest value.
Interesting question .... given the topic title!

Replies
7
Views
1K
Replies
3
Views
593
Replies
2
Views
274
Replies
1
Views
183
Replies
3
Views
488

1,190,957
Messages
5,983,837
Members
439,866
Latest member
jh3268

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