My employer is using a spreadsheet for scheduling purposes.
Currently, the employee names are in a column while the assigned times are in other columns. This is the primary worksheet (named Schedule).
They wish to add a worksheet (named Lineup) that matches the employee name and assigned times from the primary worksheet so that it populates the new worksheet with the appropriate name based on the time.
I've had success with the LOOKUP and VLOOKUP function, but the problem is that multiple people have the same time. So I end up with duplicate values, or the "N/A" error.
It's probably easier exemplified by looking at the actual file so I've attached the excel file for viewing if anyone would like to help.
for a start you'll have problems with look up as the lookup vector Schedule!B4:B49 has to be sorted ascending, what do yoe expect to get from
=LOOKUP("$**** 3",Schedule!B4:B49,Schedule!A4:A49)
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
The formulas are intended to return a name. I thought the sorted order might pose a problem. Thanks for the reply!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks