I need a logical formula with 3 outcomes

I am comparing two sets of data where a customer can have multiple products, up to about 16, each listed on a separate row. I need a formula that can compare the two lists and return a result.
If the two products (cells) match I want to return "match"
If the two products (cells) don't match but are populated (i.e. not blank) I want to return "mismatch"
If there is a product in one of the two cells but the other cell is blank I want to return "no match"
I have tried messing about with IF's and AND's but cannot seem to get the right result across all the permutations.
Thanks

It would help if you attached a sample Excel workbook, so that we can see how your data is laid out.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon (Attachments button) does not work on this forum, so don't try to use that.

Hope this helps.

Pete

Please see attached, I have annonymised the data.
The Service Description from Source 1 is to match up against the Material Description in Source 2. There are gaps in the data where it doesnt exist in one of the soruces. The contract numbers are there to match up the customers as they dont all have the same names. Quantity, value and total can be ignored at this time.

Hi Shukla, thanks for your help but the mismatch part is missing. All the mismatches are treated the same as no matches.

Sure, please see attached

Try:

=IF(COUNTIFS($A$3:$A$40,G3,$B$3:$B$40,H3,$C$3:$C$40,I3),"match",
IF(COUNTIFS($B$3:$B$40,H3,$C$3:$C$40,I3)+COUNTIFS($A$3:$A$40,G3,$B$3:$B$40,H3)+COUNTIFS($A$3:$A$40,G3,$C$3:$C$40,I3),
"mismatch","no match"))

That's great, both of your formula's give the same correct results except for the first row. They both say mismatch rather than no match.

Perfect, thank you Shakla!

Hello again, I've hit a slight problem. Whilst your formula worked i can see that you have used the customer names in there as well. In the actual spreadsheet these are not always the same, in fact in most cases they're not. There's different formatting, i.e. underscores instead of spaces and some time different suffixes, i.e. Ltd and Limited etc. Therfore I need reference to the customer names removed. I tried this and it worked, but then i hit the snag of mismatches and nomatches where there shouldn't be.
I've uploaded some more data into the spreadsheet and you can see what i've added at the bottom. Throughout the spreadsheet i've aligned the horizontal rows where they should be aligned so would be happy if the searches just took place across the row rather than down the whole column. Unfortunately i'm not adept enough to make the alteration to the formula myslef.
Thanks.