Hi
I'm trying to get a complicated conditional formatting formula to work (weekday along the top and shift code down the side), we have over 50 shift codes so I'm trying to get a VLOOKUP within the formula, my formula is:
=and(e$1="Monday,vlookup($C$2,Sheet2!$B:$D,3,false)="y")
Sheet2 has a table with the shift codes and which days they are due in (Y/N). When I apply the formula it says there is an error, how can I solve this?
You'd need to attach a sheet, so that we can see what you're doing - but there is certainly a " missing after Monday.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I can't see your sheet, but something I mocked-up worked fine with this:
Formula:
Please Login or Register to view this content.
I've fixed the " after Monday and it works.
Grand. If that's it, can you mark the thread as solved and (preferably) click the Add Reputation button at the foot of this post?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks