Return TRUE or FALSE if conditions met

Hi, I'm looking to write a formula that will take a value, say an email address from a cell and then look for it in another work sheet, if it finds it the formula will then look in a specific column in that sheet for another specific value which will be defined in the formula, if that is then found it will return TRUE, if not it will return FALSE.

Any help is greatly appreciated, I've managed to have a work round for a long time but this really needs to be collated for the work I am doing.

Please post a sample sheet with some data and expected results. See yellow banner for how-to

Welcome to the forum, but your post is too vague for us to recommend a specific formula, without a lot of assumptions on our part. You refer to "a cell containing an email address" - well, which cell is it, and will it only contain one email address?

You want to look in "another sheet", but what is the sheet name, and which column might the email address be in? Then you want to look in another column for a "specific value". Which column is this, and what is the specific value?

It would save a lot of time if you attached a sample workbook. Instructions on how to do this are given in the yellow banner at the top of the screen.

Hope this helps.

Pete

Apologies, find attached.

The cell containing the email address will only contain that specific value, the value would then be in the same format (in its own cell) in another cell, the second value to check for would be mixed in like shown in the attached document, spaced with +s, I would only want to check for that specific value like in the example below.

For example I would want to look for ab email in Sheet2 and then look at if F12 is contained in the B column, if those two conditions are met then return TRUE.

The same for gh email and B1, which would return FALSE.

Apologies I can only write the address as ab email and gh email as the proper email address counts as a link which I cannot yet post.