Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup (newbie, STILL)
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
Thanks Dave. I'll give this a try.
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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. Ken wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
#N/A error with VLOOKUP | Excel Discussion (Misc queries) | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
Vlookup with VBA | Excel Discussion (Misc queries) |