Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Advanced Macro Question

Posted on 2004-10-22
4
Medium Priority
?
141 Views
Last Modified: 2010-05-02
Greetings,
I'm building a macro and I need some help.

Suppose I have information in Columns "A" and "B" that never change:
Column A: Suporvisor's Name
Column B: Employee Name

Now suppose I put information into Column D
Column D:  Employee Name (The names are the same names in column B, however, they might be on different rows)

I need the macro to put the proper suporvisor's name into column e.

Example:  Suzy is in cell b4.  Her suporvisor, Linda, is in cell a4.  Now suppose I type Suzy's name in cell d50.  I need Linda's name to appear in cell e50.

Thoughts?

Thanks!
John
0
Comment
Question by:dandm2003
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:ampapa
ID: 12383946
A simple Vlookup should work, given your supervisor and employee range is A1:B50 and you switch your columns of Supervisor and Employee:

Cell E50's formula "=vlookup(d50,"A1:B50,2,"False")"
0
 

Author Comment

by:dandm2003
ID: 12384047
The formula works, but I forgot to ask if there is a way it can ignore if it is in CAPS for not.

For example, everything in column B is lowercase ("Kathy"), but column D is uppercase ("KATHY")

Any thougths?  Sorry I forgot to mention this!
0
 
LVL 8

Accepted Solution

by:
ampapa earned 2000 total points
ID: 12384199
Sure.

This - ("Kathy") is ProperCase and not Lowercase, as a note.

"=vlookup(proper(d50),"A1:B50,2,"False")"

Lowercase would be:

"=vlookup(lcase(d50),"A1:B50,2,"False")"

One other quick note is that the data in column A should be sorted.

0
 

Author Comment

by:dandm2003
ID: 12384231
Works perfect now.  Thanks for the help!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question