Find value in same position with specific word in next cell.

  Hi everyone, I've two cells(A and B) with values separated by pipes. For a specific word in column B I'd like to fetch the value from column A which is in the same position as the specific word i...