Hello forum,
The attachment is a modified version of the doc I am working on, but shows the problem that is cropping up elsewhere.
The problem is the LOOKUP() formula should be looking for the appropriate cell in Roster!L column, and copying the corresponding cell from Roster!B column, it works perfectly for a few, but fails on others, although the only diffrence I can see is the unique reference cell...
Sheet1!A82 should be pulling in "Collins" from Roster!B28 (via Roster!L28) It pulls in all previous names but stumbles on this one for some reason.
In the full version (another version with all 4 days implemented), it also drops names in between others (on other days), so it'll show '0' before continuing on with names. The formula is dragged down, and I can't see a reason why it should stop working *baffled*
Any help on this would be greatly appreciated.
Bookmarks