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?
Bookmarks