Nested if 10 / Vlookup

  • Thread starter Thread starter seskridge
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with VLOOKUP 4
Nested IF statement 3
Nested IF statement with VLOOKUP 1
nested if 3
Excel 2003 - Nested IF functions, VLOOKUP, or something else? 2
Nested IF Help 3
Nested IF statement 4
Need help with nested funciton using vlookup 6

Back
Top