Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup value needed
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup value needed
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup value needed
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup value needed
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Deepak" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help needed with lookup tables.. | Excel Discussion (Misc queries) | |||
Some kind of lookup needed? | Excel Worksheet Functions | |||
LOOKUP Formula help needed | Excel Discussion (Misc queries) | |||
Lookup help needed | Excel Worksheet Functions | |||
Vertical lookup help needed | Excel Worksheet Functions |