Using Formulas with different worksheets

[Emmasu]

Hi, sorry in advance if this question has already been answered.

I would like to compare two sets of date from different table, in the Table A I have a field with single select date that i want to compare with the Table B with multiple select, if in the Table B one of the data is the same I want to show the name of the person. 

If you need a context, I want to see the mentors that can help a student from a field that they choose, the mentors have given us many area of expertise and the student just one area of expertise, so from those two datas i want to do the matching and see the name of the mentors that can help this student.

Thanks in advance!

[Sho]

Hi @Emmasu ,

It is possible with automation.
Automation is triggered when a single select date is entered and updated in Table A (student list).
The mentor must be asked to enter the date in advance.

Automation:

• When a record is updated
  Watch the date field of Table A
• Find records
  Find multi-select dates in Table B that contain any of the dates in Table A
• Update record
  Update list of mentor names in the Single line text field
  or update the list of record IDs in the Record Link field

How about this?

[TheTimeSavingCo]

You could also try creating a new table called "Expertise" and converting your select fields to linked fields to that table.  You can then just add a lookup field in Table A to pull over the Mentors that have that expertise set