Hi
it just tells the MATCH function to look for an exact match. See Excel's
helpt for more on this third parameter of the MATCH function

--
Regards
Frank Kabel
Frankfurt, Germany
"Ken" schrieb im Newsbeitrag
ink.net...
Dave,
The 0 at the end of this formula... does it tell the program to look in
the first column for a match? I was thinking the 2 in my original formula
was telling the program to look in the second column. Just wondering.
Thanks,
Ken


"Dave Peterson" wrote in message
...
=index(g19:g23,match(min(h19:h23),h19:h23,0))

Debra Dalgleish has some nice instructions for =vlookup() and
=index/match at:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

Ken wrote:

I have =vlookup(h25,g19:h23,2,false) which returns a number when I type
a
name. How can I reverse this? Basically, I am using MIN in a formula in
column B and when I get the result of the MIN formula I would like it to
return the corresponding name from column A. I am using cells B1, B3,
B5..... thru B15 and A1, A3, A5.... thru A15. Column B MIN gives me a
number
00.00 and I need the name in column A to be the result of the vlookup.
Incidentally the vlookup I mentioned at the beginning came from this
group.
I've not progress enough to do this on my own as of yet. Obviously.
Thanks,
Ken

--

Dave Peterson