Climaxgp
Forum Contributor

if i want to see some word in a cell: means:like in A1: car is costly then cycle
In A2 : computer is cheaper then bike
In A3: watch is very important for me

i want to know from you is there any formula which if i search (car,computer,watch)
then in B1 value return should be : car
B2: computer

thanx in advance

pls mail me the sol directly

sunny malhotra
sunny_malhotra@lntenc.com