Forum Discussion

Rhonda's avatar
Rhonda
Copper Contributor
Jan 31, 2025

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 them with their issue. What I am attempting to do is to create an easy way for my co-workers and myself to be able to quickly find the therapist based on the issue. Here is what I am trying but keep getting my formula wrong.  Please help.  Rhonda

 

  • 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.

  • Rhonda's avatar
    Rhonda
    Copper Contributor

    Thank you so much! I did rearrange my table and this formula worked.  I am very grateful.

    Rhonda

  • luchete's avatar
    luchete
    Iron Contributor

    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!

    • Rhonda's avatar
      Rhonda
      Copper Contributor

      Luchete

      Thank you for the suggestions. I will try to put them to use this week and let you know how it goes.

       

      Rhonda

    • Slowhandman's avatar
      Slowhandman
      Copper Contributor

      Rhonda... I use coPilot to help with my Excel problems

      are you using VBA to help solve your concerns?

    • BTSonchkh's avatar
      BTSonchkh
      Copper Contributor

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

  • IAHernandez's avatar
    IAHernandez
    Copper Contributor

    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.

Resources