vlookup (newbie, STILL)

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

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,
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
 
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 said:
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
Click to expand...
 
Just to add to Frank's reply.

=vlookup() has that return this column parm.

But =match() doesn't.

And if you noticed, each of those ranges consisted of exactly one column:
G19:G23
and
H19:H23

It was just returning the value from the same row in G19:G23 that had the match
in H19:H23.
 
Thank you both for the information. The MATCH formula worked well and it is
greatly appreciated.
Ken
 
Back
Top