Lookup value needed
in [General]
|
From: Deepak on 5 Jul 2008 01:01 I have a sheet which has 4 coloums A B C D Don 115 Don 50 Don 125 Mary 85 Mary 15 John 10 Phil 25 Phil 35 Using the formula I want to pull up the lowest value next to names value in Coloum "C" & "D" Basically it should pull up the lowest value from coloum B refrencing to coloum A ===============it should look like this ====== C D Don 50 Don 50 Don 50 Mary 15 Mary 15 John 10 Phil 25 Phil 25 Thanks for the help in advance Deepak maildpak(a)inbox.com
From: T. Valko on 5 Jul 2008 02:21 Not sure why you want to repeat the names in column C... Enter this formula in C1: =A1 Enter this array formula** in D1: =MIN(IF(A$1:A$8=A1,B$1:B$8)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Select both C1 and D1 then copy down as needed. -- Biff Microsoft Excel MVP "Deepak" <Deepak(a)discussions.microsoft.com> wrote in message news:62EA4DEC-47CF-40C7-94A9-CD2420744D35(a)microsoft.com... >I have a sheet which has 4 coloums > A B C D > Don 115 > Don 50 > Don 125 > Mary 85 > Mary 15 > John 10 > Phil 25 > Phil 35 > > Using the formula I want to pull up the lowest value next to names value > in > Coloum "C" & "D" > > Basically it should pull up the lowest value from coloum B refrencing to > coloum A > ===============it should look like this ====== > C D > Don 50 > Don 50 > Don 50 > Mary 15 > Mary 15 > John 10 > Phil 25 > Phil 25 > > Thanks for the help in advance > > Deepak > > maildpak(a)inbox.com > >
From: Deepak on 5 Jul 2008 02:42 You are the Dude :) Thanks a Ton.................................................. ------------------------------------------------------------ "T. Valko" wrote: > Not sure why you want to repeat the names in column C... > > Enter this formula in C1: > > =A1 > > Enter this array formula** in D1: > > =MIN(IF(A$1:A$8=A1,B$1:B$8)) > > ** array formulas need to be entered using the key combination of > CTRL,SHIFT,ENTER (not just ENTER) > > Select both C1 and D1 then copy down as needed. > > > -- > Biff > Microsoft Excel MVP > > > "Deepak" <Deepak(a)discussions.microsoft.com> wrote in message > news:62EA4DEC-47CF-40C7-94A9-CD2420744D35(a)microsoft.com... > >I have a sheet which has 4 coloums > > A B C D > > Don 115 > > Don 50 > > Don 125 > > Mary 85 > > Mary 15 > > John 10 > > Phil 25 > > Phil 35 > > > > Using the formula I want to pull up the lowest value next to names value > > in > > Coloum "C" & "D" > > > > Basically it should pull up the lowest value from coloum B refrencing to > > coloum A > > ===============it should look like this ====== > > C D > > Don 50 > > Don 50 > > Don 50 > > Mary 15 > > Mary 15 > > John 10 > > Phil 25 > > Phil 25 > > > > Thanks for the help in advance > > > > Deepak > > > > maildpak(a)inbox.com > > > > > > >
From: T. Valko on 5 Jul 2008 22:30 You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "Deepak" <Deepak(a)discussions.microsoft.com> wrote in message news:A16C4DB3-F21F-41B0-BB02-620D9E12ED4F(a)microsoft.com... > You are the Dude :) > > Thanks a Ton.................................................. > ------------------------------------------------------------ > "T. Valko" wrote: > >> Not sure why you want to repeat the names in column C... >> >> Enter this formula in C1: >> >> =A1 >> >> Enter this array formula** in D1: >> >> =MIN(IF(A$1:A$8=A1,B$1:B$8)) >> >> ** array formulas need to be entered using the key combination of >> CTRL,SHIFT,ENTER (not just ENTER) >> >> Select both C1 and D1 then copy down as needed. >> >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "Deepak" <Deepak(a)discussions.microsoft.com> wrote in message >> news:62EA4DEC-47CF-40C7-94A9-CD2420744D35(a)microsoft.com... >> >I have a sheet which has 4 coloums >> > A B C D >> > Don 115 >> > Don 50 >> > Don 125 >> > Mary 85 >> > Mary 15 >> > John 10 >> > Phil 25 >> > Phil 35 >> > >> > Using the formula I want to pull up the lowest value next to names >> > value >> > in >> > Coloum "C" & "D" >> > >> > Basically it should pull up the lowest value from coloum B refrencing >> > to >> > coloum A >> > ===============it should look like this ====== >> > C D >> > Don 50 >> > Don 50 >> > Don 50 >> > Mary 15 >> > Mary 15 >> > John 10 >> > Phil 25 >> > Phil 25 >> > >> > Thanks for the help in advance >> > >> > Deepak >> > >> > maildpak(a)inbox.com >> > >> > >> >> >>
|
Pages: 1 Prev: How do I add column headings to the single sheet. Next: FINDING TOP 20 (URGENT PLEASE) |