Cashier time log Lookup
Hi All
I must be doing something wrong - I end up with circular reasoning.
I have attached a sample of what data I have.
Say at Till 1, there is 6 cashiers for the day, and I want to Validate data for till one (Selecting till 1 from the drop down), I only get one cashier's name and not all 6... And then how do i get a vlookup to bring back the start and] end of their shift.
(I struggle to insert the attachment - Hopefully it works) Looking forward to the help!!
Hi ronettes,
VLOOKUP only returns the first match it finds.
For simplicity I took the liberty of making a lookup table in column G:H and another drop down in M2 for the dates.
Then in K7:K17 this formula to return cashier #s.In M7:N7 this formula to return the times.Formula:
Please Login or Register to view this content.This returns the start and end times, but it appears that on 7/21/2016 cashier # 70 works two shifts on till 1. The formula only returns the start of the first shift and the end of the second. Is this what you want?Formula:Please Login or Register to view this content.
Dave
Hi FlameRetired
I would have NEVER EVER Thought of thisWELLDONE!!
Thank you soo Much!!!
Hi FlameRetired
Will it be possible to use the countif formula to count next to the cashiers time (End of shift) How many times they had a sale in the time of their shift?
Assuming that each entry represents a sale, try pasting this formula in O7 and copy down:Let me know if you have any questions.Formula:Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMc
Thank you so much!!its Brilliant!!!
You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks