Comparing two names

[Mike]

I have a worksheet as follows:

Broker Name Broker Code Contact
ABC Mtg A123 Bob
XYZ Financial B323 Phil
Blah Mtg A444 Charles

On another sheet I have their production numbers as such:
Broker Name Broker Code Loan Number Closed
ABC Mtg A123 123456 7/1
ABC Mtg A123 234567 7/2
Blah Mtg A444 987654 7/2
XYZ Financial B323 1230001 7/3

Basicaly what I want to do is this, in the second sheet instead of manually
putting in the broker name, I would like it to look at the broker code and
find that broker code on the first sheet and put the name of that broker in
the second sheet. Seems crazy but it helps me with another part of the
wookbook to make sure the names are exactly the same. Can you help me?

 

[Teethless mama]

Sound like INDEX & MATCH functions. Look in the Excel Help menu

 

[Toppers]

In your second sheet:

in A2:

=INDEX(Sheet1!$A$2:$A$4,MATCH(B2,Sheet1!$B$2:$B$4,0))

copy down

 

[Mike]

Thank you so much Toppers! Perfect!

In your second sheet:

in A2:

=INDEX(Sheet1!$A$2:$A$4,MATCH(B2,Sheet1!$B$2:$B$4,0))

copy down