VLOOKUP & MIN - need help

[slam]

I’m trying to use a VLOOKUP to extract the value from the cell in the range of B2:B17 where there is the corresponding MIN value in the range G2:G17 on a worksheet called Australia (a different worksheet from where I need the formula)

Can’t get it to work – could someone help me out? Thanks

 

[VoG]

Try

=INDEX(B2:B17,MATCH(MIN(Australia!G2:G17),Australia!G2:G17,0))

 

[slam]

Try

=INDEX(B2:B17,MATCH(MIN(Australia!G2:G17),Australia!G2:G17,0))

Thanks - maybe I didn't quite explain it right - B2:B17 was also on the Australia worksheet, but that got me close enough to figure it out. This is what worked for me:

=INDEX(Australia!$B$2:$B$17,MATCH(MIN(Australia!G2:G17),Australia!G2:G17,0))

So I tried it using numbers like 1, 2, 3 etc and it works that way. However, my cells are formatted as mm:ss.000 and it doesn't work then.

Any solution to that?

 

[VoG]

It works for me with cells containing times.

 

[slam]

It works for me with cells containing times.

I can get it to work with times, but not

mm:ss.000

Is the milliseconds messing it up?

 

[VoG]

It is working here. Are the times definitely numbers. What does

=ISNUMBER(G2)

return?

Excel Workbook
	B	C	D	E	F	G	H	I	J
1									12
2	37					09:23.825	00:12.340
3	38					49:31.509
4	12					00:12.340
5	40					07:21.147
6	56					21:19.189
7	89					56:19.020
8	57					09:39.126
9	20					12:39.536
10	88					52:12.507
11	38					03:21.712
12	68					44:34.670
13	1					58:43.029
14	8					05:40.474
15	7					17:33.377
16	42					30:13.749
17	24					52:31.618
Australia

 

[slam]

Sorry, I got it working. I think my times were actually entered with a period instead of a colon.

1.23.123
instead of
1:23.123

Thanks!