Forum Discussion
New City of LA Law Requires Multiple Square Footage Calculations
The City of Los Angeles recently implements a law which limits housekeeping staff in hotels to clean less than 5000 square feet in any 8 hour shift (these numbers may be reduced for a number factors)...
=INDEX($B$3:$B$96,MATCH(E3,$A$3:$A$96,0))You can try INDEX and MATCH as shown in the example.