Formula to check multiple values?! I'm stuck! :(

Hi all,
I'd appreciate some guidance on this one if possible!

I have a spreadsheet of item codes from my business and I need to know if we have high resolution images of them. Please refer to the attachment.

In Column A I have a list of products we SHOULD have hi-res images for.
In Column C I have a list of images that we already have.

I can find which images we have using VLOOKUP, that's not a problem. But before I do that I need to be able to tell which of the images are high res.

Is there a formula that would tell me if, say, C2 has the text "jpg" somewhere in the cell, and if the corresponding file size for that particular cell in column E is lower than 4MB? I need a formula that will tell me if both of those "ifs" are true, as this means the image is too low res and needs to be removed.

I hope this makes sense, if you need anything else please let me know!
Thanks in advance for any help you can give!

- Skye

Hi there. Is this what you wanted?

Formula:

Please Login or Register  to view this content.

Try this.....

Please Login or Register  to view this content.

This formula will return True or False as per your conditions.
**I have changed some products in column A.

Is this what you are trying to achieve?

Which one worked??

Odd. I thought it wasn't what you wanted, as it showed "No" for any tif images and also for jpgs less than 4 MB.

If modified like that, then it does work. However "search" might be better than "find" (it's not case sensitive and a lower case m gives you an "#value" error in the version you're now using.