Forum Discussion
Rhonda
Jan 31, 2025Copper Contributor
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.
- RhondaCopper Contributor
Thank you so much! I did rearrange my table and this formula worked. I am very grateful.
Rhonda
- lucheteIron 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!
- RhondaCopper 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
- SlowhandmanCopper Contributor
Rhonda... I use coPilot to help with my Excel problems
are you using VBA to help solve your concerns?
- BTSonchkhCopper Contributor
https://techcommunity.microsoft.com/discussions/microsoftlearn/help-with-formula/4372522/replies/4372888
- IAHernandezCopper 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.