• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

Advanced Macro Question

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.


  • 2
  • 2
1 Solution
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")"
dandm2003Author Commented:
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!

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


Lowercase would be:


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

dandm2003Author Commented:
Works perfect now.  Thanks for the help!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now