I want to search a cell in a report where supervisors report staffing
actions. When overtime is worked they may note it as O/T, OT or ot. I was
wondering if it is possible to put these values in a table then use that
table to search the cell in the form something like
= IF(ISERROR(SEARCH(Vlookup(cell, table, reference),$C3,1)),FALSE,TRUE)
where C3 may contain something like "J Blow 800 - 400/ 400- 600 O/T"
to return true if one of the strings in the table is found or false if it is
not found.
Or is there a better way to do this?
thanks
Bookmarks