What function do I use in order to...

plahen

New Member
Joined
Nov 3, 2004
Messages
17
In column H I have a list of 15 values in random order

In column B I have a list of 15 values in random order

This spreadsheet is locked

Here is the question

I want to take the maximum value in column H and return the value from teh same row in column B into another spreadsheet.

Thanks in advance
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

hayden

Board Regular
Joined
Sep 23, 2005
Messages
159
I think you could use a vlookup comand for this.

The syntax of vlookup is vlookup(lookup_value,table_array,col_index_num,range_lookup)

Lookup value would be max(range in col H)
Table Array would be range a1:h15 assuming that your data was in the frist 15 rows.
col_index _num would be 2 (i.e. b)
range lookup can be left out, or can be set to false. I would suggest reading the help on the vlookup command for more on this.

The one thing I don't know is if you can still get values even though the sheet is locked.

Good Luck

Hayden
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
How's this:

=INDEX(Sheet1!$B$1:$B$15,MATCH(MAX(Sheet1!$H$1:$H$15),Sheet1!$H$1:$H$15,0),0)

HTH,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,114,095
Messages
5,545,923
Members
410,713
Latest member
TaremyLunsil
Top