Looking to do a vlookup or if something

rcirone

Active Member
Joined
Mar 12, 2009
Messages
483
Office Version
  1. 365
Platform
  1. Windows
I am trying to find the manager of agents. This is what I have trying to find the manager for the agent on the listed.

manager
Agents List
DuranAndrew Andrew
DuranAndrew Constance
DuranAndrew Curtis
DuranConstance Greg
DuranConstance Thalia
DuranConstance Alisha
DuranCurtis Amber
DuranGreg Bradley
JosephThalia Crystal
JosephThalia
JosephThalia
JosephThalia
KimAlisha
KimAmber
KimBradley
KimCrystal

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Try

=INDEX(A:A,MATCH(E2,B:B,0))

A:A = all managers
B:B = all agents

E2 = the agent you want to find the manager of.
 
Upvote 0
managerAgents List
DuranAndrew AndrewDuran
DuranAndrew ConstanceDuran
DuranAndrew CurtisDuran
DuranConstance GregDuran
DuranConstance ThaliaJoseph
DuranConstance AlishaKim
DuranCurtis AmberKim
DuranGreg BradleyKim
JosephThalia CrystalKim
JosephThalia
JosephThalia
JosephThalia
KimAlisha
KimAmber
KimBradley
KimCrystal



<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
this is assuming that you have "manager" in a1 copy this and paste it next to andrew on the list then copy it down.

=INDEX($A$3:$A$18,MATCH($E3,$B$3:$B$18,0))
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top