Search client list for employee

[BitterGreg]

I have a master list of clients for my company in column A, and in column B it has the assigned employee for that client. What would the formula be if I was created a separate sheet that had select clients on them and wanted to pull the employee from the master list? I have attached a simple sheet. I want to have a formula to have the employee names pulled from the master list and input into column F.Sample Sheet.xlsx

[BadlySpelledBuoy]

Try this in F2 and copy down:

Please Login or Register  to view this content.

BSB

[misrasomendra]

Hi,

Use in F4 and copy down:

=VLOOKUP(E4,$B$4:$C$13,2,0)

Regards,

[MarvinP]

Hi Greg,

This looks like a simple (if anything is simple) VLookup formula solution. See the attached.