Matching System for Dating Application

[excellenct]

Hi Guys,

I need to create a complex matching system on GSHEET (or Excel) for something similar to a dating application. Profiles and criteria are entered via a Google Form. The table below might give a rough idea of the sort of rules I need to create:

Person 1 Profile	Person 2 Profile	Criteria set by 1+2 (match both ways)
Postcode	Postcode	Distance
Date of Birth	Date of Birth	Minimum Age, Maximum Age
Specification 1 (Options A-Z)	Specification 1 (Options A-Z)	Criteria 1 (Options A-Z)
4 sets of specifications in separate columns (Options A-Z x4)	4 sets of specifications in separate columns (Options A-Z x4)	Criteria 2 (Options A-Z)

I can post more details if needed. Any indicators on where to start will help.

Thanks in advance

[protonLeah]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

---

Want to get your question answered quickly?

• Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
• On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
• Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
• Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
• Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
• If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.