Simple Formula Correction

Job ID: 37703832

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
Related categories: Excel Google Sheets