Forum Discussion

Rhonda's avatar
Rhonda
Copper Contributor
Jan 31, 2025
Solved

Help with Formula

Hello, This is my first post here and I can sure use the help. I work in the counseling field as an appointment coordinator. In my job I try to match people with the therapist that can best help the...
microsoft 365
  • IAHernandez's avatar
    IAHernandez
    Feb 01, 2025

    Hi Rhonda, I use xlookup formula often, but using only 2 columns ranges from the table. I do not have duplicate values when I am searching for something. I suggest trying to consolidate the therapists with the conditions without repeating conditions. 

    Just an example.

luchete's avatar
luchete
Iron Contributor
Feb 01, 2025

Hello Rhonda!

Seems you're trying to match therapists to issues quickly. If you want a formula to help with this in Excel, you could use a combination of VLOOKUP or INDEX and MATCH to search for the issue and return the corresponding therapist. For example, in the table with therapist names and their specialties ( i assume is "Therapy pract"), you can use VLOOKUP to look up the issue/condition and return the name of the therapist that matches. 

Hope it helps!

BTSonchkh's avatar
BTSonchkh
Copper Contributor
Feb 02, 2025

https://techcommunity.microsoft.com/discussions/microsoftlearn/help-with-formula/4372522/replies/4372888

Resources