V look up to match a set of numbers and return initials

[dlb]

First, thank you for your time, I can not tell you how much I appreciate your expertise.

I have a spreadsheet with 3000+ entries identified by department number instead of director.

Each director has 1 - 7 departments. I need to add a column listing the Director for each department.

Initials.....Department number
BS.........7400
BS.........7550
BS.........7540
BS.........7570
BS.........7490
DS.........7975
GG.........7315
GG.........7320
GG.........7325
GG.........7430
GG.........7465
GG.........7500

 

[texasalynn]

so a vlookup would be

=vlookup(b2,tablerange,columnref,false)

where tablerange is where a table has the departments and initials list
and columnref is the column number sequence where the initials are found within the table range

Would be better to give you an exact formula with a sample of your data in the table list