evaluate multiple conditions

[pdeshazier]

i have an excel spreadsheet with benefits information. one column (B)contains plan name for which i need to search for either "20" or "25" THEN i need to check a second column (D) for 3 or 4 different values and based on each condition (ex. there are four different scenarios for when the first column contains "20" as well as when it contains "25"), i need to place a value in a new column (our withholding code). what's the best way to do this? i'm under a tight deadline and would appreciate any help. thanks.

[Bob Phillips]

What are the forur values, where does the result go? You get a better response to a (much) better question.

[Bob Phillips]

What are the forur values, where does the result go? You get a better response to a (much) better question.

[pdeshazier]

**RESULT WILL GO IN WHATEVER NEW COLUMN I INSERT

column B will contain either 20 or 25. column D will contain either EE + FAM, EE + CHI, EE + SP, or EE. desired values (in new column) for B contains "20" are:
44 (when B=20 and d=EE)
54 (when b=20 and d= EE + SP)
59 (when b=20 and d= EE + CHI)
64 (when b=20 and d= EE + FAM)

desired values when b contains 25:
47 (when b=25 and d=EE)
57 (when b=25 and d=EE + SP)
62 (when b=25 and d=EE + CHI)
68 (when b=25 and d=EE + FAM)




What are the forur values, where does the result go? You get a better response to a (much) better question.