Retrieving value from list based on dynamic condition

R

rz6657

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Dynamic list on a cell 2
Conditional Formating based on Data Validation 3
VALUE err calculating indirect number 5
Return a "" value from a formular 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Automate sheets list 1
Condition based on multiple cells 4

Top