#### rangeralex

##### New Member

- Joined
- Jan 3, 2013

- Messages
- 20

I’m trying to do something more complicated, but this is essentially what I am stuck on. Let’s say we have Four cells where A1=100 (Option 1); B1=200 (Option 2); C1=300 (Option 3); D1=400 (Option 4). In a different cell; let’s call it A2, I have a drop down list with “Option 1, Option 2, Option 3, and Option 4” listed. Finally, I have a cell that is used for what I hope to be the “result” cell, let’s dub this one B2. What I am trying to accomplish is by selecting “Option 3” from the drop down menu in cell A2, the result of 300 will populate automatically in the results cell, B2. Make sense?

I have tried using =vlookup and the =if function, but the problem I am having is there is no way to tell excel to try a different option if the one given doesn’t work. Any suggestions?

Thanks