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

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

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

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