| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieving value from list based on dynamic condition
Help I need to retrieve a value from a list based on a dynamic condition. For example: 1. Let's say that cell F10 will be populated by a dynamic # between 1 - 80. 2. Based on that #, a formula in cell F11 will need to retrieve from a list the corresponding description associated with the dynamic # in F10. dynamic cell F10 - 3 results in cell F11 - Visual Contact List - Cell H10 = 1 and cell I10 = Volume Cell H11 = 2 and cell I11 = Posture Cell H12 = 3 and cell I12 = Visual Contact and so on... Please help. Thanks. Rik -- rz6657 ------------------------------------------------------------------------ rz6657's Profile: http://www.excelforum.com/member.php...o&userid=37572 View this thread: http://www.excelforum.com/showthread...hreadid=572028 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving value from list based on dynamic condition
One way - use VLOOKUP
In F11: =IF(F10="","",VLOOKUP(F10,$H$10:$I$100,2,0)) Adjust the table array to suit: $H$10:$I$100 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "rz6657" wrote: Help I need to retrieve a value from a list based on a dynamic condition. For example: 1. Let's say that cell F10 will be populated by a dynamic # between 1 - 80. 2. Based on that #, a formula in cell F11 will need to retrieve from a list the corresponding description associated with the dynamic # in F10. dynamic cell F10 - 3 results in cell F11 - Visual Contact List - Cell H10 = 1 and cell I10 = Volume Cell H11 = 2 and cell I11 = Posture Cell H12 = 3 and cell I12 = Visual Contact and so on... Please help. Thanks. Rik -- rz6657 ------------------------------------------------------------------------ rz6657's Profile: http://www.excelforum.com/member.php...o&userid=37572 View this thread: http://www.excelforum.com/showthread...hreadid=572028 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving value from list based on dynamic condition
Max - Thanks for the solution. It worked and it saves me alot of time. Thanks again. -- rz6657 ------------------------------------------------------------------------ rz6657's Profile: http://www.excelforum.com/member.php...o&userid=37572 View this thread: http://www.excelforum.com/showthread...hreadid=572028 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Retrieving value from list based on dynamic condition
You're welcome !
Thanks for calling back .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "rz6657" wrote: Max - Thanks for the solution. It worked and it saves me alot of time. Thanks again. -- rz6657 ------------------------------------------------------------------------ rz6657's Profile: http://www.excelforum.com/member.php...o&userid=37572 View this thread: http://www.excelforum.com/showthread...hreadid=572028 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a dynamic list?! | Excel Discussion (Misc queries) | |||
| update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
Hybrid Mode
