There two columns lets say A & B. Both contains text for e.g A : A1=apple,
A2=ball, A3=cat..... and B: B1= cat,dolphin,bear , B2=apple,orange,banana ,
B3=ball,box,bat.....

now i want to search the value of a cell in A Column lies where in B
column...i.e. A1 lies in B2, A2 in B3 and so on....

which formula can do the job?