Simple Formula Correction
Budget: $10 – $30 USD
Check this sheet: On sheet 1 its supposed to highlight any value where its in sheet 2 and then that row on column h it also says "OFF OFFICE"
For some reason it stops working if it finds something that doesnt match.
See the test sheet here...
https://docs.google.com/spreadsheets/d/1OXhZwopG07tDmJljTY7WZTATN_5YpcmH3bM6NhXu-XI/edit#gid=0
For some reason it stops working if it finds something that doesnt match.
See the test sheet here...
https://docs.google.com/spreadsheets/d/1OXhZwopG07tDmJljTY7WZTATN_5YpcmH3bM6NhXu-XI/edit#gid=0