|Date:||Mon, 2 Mar 2009|
I am trying to search fro two pieces of infomation from one cell.
For one piece i have used =IF(LEFT(J11,2)="Ph",L11,""). What i want to be
able to do is search for either "Ph" or "In" from the same cell. Is this
possible? I think i have seen this done by setting a special function and