I use the following formula to look up whether or not the contents of specified cells fall between the parameters in a look up table.

- Code: Select all Expand viewCollapse view
`=IF(ISERROR(IF(OR(T769<VLOOKUP(V769;$AB$5:$AD$26;2;0);U769>VLOOKUP(V769;$AB$5:$AD$26;3;0));1;0));"";IF(OR(T769<VLOOKUP(V769;$AB$5:$AD$26;2;0);U769>VLOOKUP(V769;$AB$5:$AD$26;3;0));1;0))`

Columns T and U contain a time and column V contains a name. Likewise columns AB and AD contain reference times and AD contains the reference name.

This formula works perfectly however I now need to amend it so that if the name in column V equals 'Floor Sweep', 'Floor Wash', 'Toilets', 'Restaurant' or 'Rubbish / Spillages' it returns 0. If the name equals something else the formula would then continue as per the original formula outlined above.

Your help will be greatly appreciated!