Hi all,

Trying to do some scheduling work and struggling...

Basically I have a spreadsheet that in the first column lists a specific number (unique to my industry), and in the 9th column the name of an employee. In a second sheet, I'd like to create a row of names that auto generates by looking up the specific number.

For example:
1st column
18
16
18
20
21
20
7

9th column
Mark
Bob
Jill
Ashley
Sam
David
Peter
Now the second sheet would ideally have a row with the headings "Mark" and "Jill" given a formula that looks up '18' in the 1st column.

Is there a modified version of a lookup formula that can handle duplicate values?