Desk booking formula problems

%3CLINGO-SUB%20id%3D%22lingo-sub-1620914%22%20slang%3D%22en-US%22%3EDesk%20booking%20formula%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620914%22%20slang%3D%22en-US%22%3E%3CP%3ECreated%20an%20HLOOKUP%20to%20show%20desk%20availability%20on%20an%20office%20layout%20diagram%20for%20any%2030%20minute%20interval.%3C%2FP%3E%3CP%3E%26nbsp%3B%3CBR%20%2F%3ESome%20of%20our%20desks%20are%20immediately%20opposite%20others%20and%20to%20maintain%20social%20distancing%2C%20I%20need%20to%20create%20a%20function%20that%20blocks%20availability%20of%20the%20opposing%20desk%20as%20soon%20as%20one%20of%20the%20pair%20is%20booked%20for%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20any%20suggestions%20of%20what%20changes%2Fconditions%20need%20to%20be%20added%20to%20my%20formula%20to%20accommodate%20this%3F%20Sample%20attached%20-%20those%20highlighted%20in%20pink%20(Row%20index%206%3A9)%20need%20changing.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1620914%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620987%22%20slang%3D%22en-US%22%3ERe%3A%20Desk%20booking%20formula%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620987%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F775608%22%20target%3D%22_blank%22%3E%40FMRLL%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EThis%20is%20not%20the%20solution%20you%20were%20looking%20for%20but%20might%20worth%20looking%20at%20it.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20approach%20is%20extremely%20simplistic%20where%20I%20paired%20the%20desks.%20instead%20of%20desk2%20and%20desk3%2C%20you%20now%20have%20desk2%2F3.%20(see%20attached.)%3C%2FP%3E%3CP%3ESo%20it's%20a%20different%20way%20to%20approach%20your%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620997%22%20slang%3D%22en-US%22%3ERe%3A%20Desk%20booking%20formula%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%20That%20is%20actually%20a%20really%20sensible%20way%20to%20approach%20the%20problem%20that%20I%20hadn't%20considered!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620998%22%20slang%3D%22en-US%22%3ERe%3A%20Desk%20booking%20formula%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620998%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20glad%20my%20laziness%20can%20help%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F775608%22%20target%3D%22_blank%22%3E%40FMRLL%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Created an HLOOKUP to show desk availability on an office layout diagram for any 30 minute interval.

 
Some of our desks are immediately opposite others and to maintain social distancing, I need to create a function that blocks availability of the opposing desk as soon as one of the pair is booked for use.

 

Has anyone any suggestions of what changes/conditions need to be added to my formula to accommodate this? Sample attached - those highlighted in pink (Row index 6:9) need changing. 

 

Thanks.

3 Replies
Highlighted

Hi @FMRLL,

This is not the solution you were looking for but might worth looking at it. 

My approach is extremely simplistic where I paired the desks. instead of desk2 and desk3, you now have desk2/3. (see attached.)

So it's a different way to approach your problem.

Highlighted

@Bennadeau 

Thank you. That is actually a really sensible way to approach the problem that I hadn't considered! 

Highlighted

I'm glad my laziness can help @FMRLL