# Formula for the use of multiple IFs and AND statements

#### Toncar58

##### New Member
Hello, for convenience I have uploaded a sheet.
I am looking for help with an appropriate excel formula to solve my dilemma. In the attached worksheet I seek a formula in column E. The conditions are If column D is "Yes" and only if yes and if column C is equal to any of the names in Column F. Then if positive to both conditions then a cell in column G otherwise the cell should be "".

To summarise, looking at row 5 in the attached sheet, I want Cell E5 to reflect "", because D5 = Yes, but C5 is not equal to any cells in column F. If however C5 read "BCA" or any other name in Column F and D5 equals "Yes" then either G5 or G6 would be the answer.

Naturally every row in column E will have the appropriately amended formula.

I hope I have explained myself correctly.

Thanks
Toncar58

#### Attachments

• Screen Shot 2021-02-24 at 15.04.33.png
60.6 KB · Views: 5

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Replies
1
Views
73
Replies
12
Views
181
Replies
6
Views
122
Replies
4
Views
167
Replies
1
Views
79

1,129,713
Messages
5,637,932
Members
416,993
Latest member
ant8989

### 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