Formula for the use of multiple IFs and AND statements

Toncar58

New Member
Joined
Feb 24, 2021
Messages
10
Office Version
  1. 365
Platform
  1. MacOS
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
    Screen Shot 2021-02-24 at 15.04.33.png
    60.6 KB · Views: 5

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,671
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,129,795
Messages
5,638,379
Members
417,025
Latest member
MusterDuster

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top