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

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
>
>

Max - Thanks for the solution. It worked and it saves me alot of time. Thanks again.

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
>
>