What would be the best way to approach this?

I have a hugh list of transactions that I need to sort on -- each
transaction has a Salesperson with falls into (2) distinct Sales Categories:
(Private) & (Commercial).

For reasons beyond my control, the decision was made not to include these
category fields on the worksheets, so I created a listing of all the
Salesperson with their corresponding Sales Categories in a separate
worksheet.


I have the following code -- which does a VLOOKUP on Cell F2
(Salesperson1!F2) against Salesperson2!A2:A4000)
CODE:

=VLOOKUP(F2,Salesperson2!A2:A4000,1,FALSE)

Here's what I'm trying to do ...

I'd like use the values in Salesperson!F2:F4000 and search for these valuse
in Salesperson!A2:A4000 -- for each corresponding MATCH (ie,
Salesperson1!F2 = Salesperson2!A2, insert the value of Salesperson2!B2 into
Salesperson1!K2).

What would be the best way to approach this? I suspect that I'll need to
Loop through records Salesperson1!F2:F4000.

Thanks in advance