How to compare columns and return one value if they match

To Attach a Workbook:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit
---------------------------------------
Choose your sample data such that some fall within the parameters while others do not.

You mean something like this?


I made 2 solutions, one solution using lots of helper cells and one single cell solution.
The single cell solution actually turned out pretty well, looks like this:

Formula:

Please Login or Register  to view this content.