Complex Scheduling and Pre-Filling Out a Different Form...

I've attached a schedule I'm working on for the restaurant I work at, I'd like to pre-fill out the Sign in and out sheet according to the start times listed on the schedule itself, but am unsure about how to do that.

I've tried VLOOKUP and HLOOKUP but seem to be having issues.

If the person has sl next to their start time on the sheet "Current" they should appear on the timesheet under leader.. sr under Servers, bs + ho, under hostesses.. etc.

If anyone could help or at least point me in the right direction that would be awesome!

Thank you,

John

You might try a combination of MATCH() and INDEX()

Match returns the position of a given value within a range
thus (using your example sheet)
MATCH("Katey",Current!C26:C41) gives the result : 3
then
INDEX(Current!C26:C41,3) gives "Katey"
More usefully
INDEX(Current(E26:E41,3) gives Katey's start time

Splitting the lookup operation into two stages in this way gives greater flexibility, which might allow you to find a solution to your problem.

Thanks, I did try using the INDEX/MATCH functions but was having issues with those as well, I'll try that again though.

I couldn't get it to work the way I wanted to, so I've had to re-tool the whole menu. Not quite what I wanted but it works, if anyone figures it out though let me know! Thanks.