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

[kylezt]

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

 

[BenMiller]

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.

 

[kylezt]

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?

 

[BenMiller]

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