Nested if 10 / Vlookup

S

seskridge

I am working on a Scheduling program for a counseling center. Thi
center has 10 + therapists and 20 + clients. The plan is for th
manager to only have to enter the clients name into the therapist page
and to have the therapists name auto populate into the clients page.
can get this to work fine with 7 therapists (the limit for nested i
statements) but I cannot figure out how to get vlookup or any othe
function to work.

ohh by the way the or() statements are used because there are
possibilities for the clients name to be entere
(CLIENT/CLIENTc/CLIENTp)





Code
 
F

Frank Kabel

Hi
could you explain there your search data is. Looking at your example it
seems that this kind of data is on separate worksheets. VLOOKUP would
work only well if you have the lookup range on a single worksheet
 
Top