# multiple nested if with 2 drop-downs and each drop-down has 5 conditions

#### kylezt

##### New Member
I am trying to create a if that looks a dropdown A (N/A, Recieved, In Review, In Review Signed, Released) each item has a value (0, 5, 7, 8, 10). Dropdown B (Not started, in work, in offload, in review, in review hold, released) each has a value (0, 20, 20, 60, 80, 90). So when dropdown A = In Review and dropdown B = In Review, my value should be 67.

I have created 1 if to provide a value for Dropdown A and one for Dropdown B, but is there a way to create 1 if that incompasses both?

This formula is used for 120 rows.

Help

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
The easiest way would be to create a two lookup tables with all the values and what they're "worth", then do a VLOOKUP+VLOOKUP.

Thanks that did it,

1 additional question, if there was a name added to "in work", example "in work ted" or "in work kb". would there be a way to add a wild card to handle that, without having to add those as a choice in the table?

I'd just use VLOOKUP(LEFT(A1,7),....) to look for the first 7 characters - "in work".

Replies
10
Views
167
Replies
0
Views
1K
Replies
3
Views
249
Replies
6
Views
193
Replies
0
Views
307

1,203,453
Messages
6,055,530
Members
444,794
Latest member
HSAL

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back