VLOOKUP TO THE LEFT

[Ruban S]

Is there any possible way is there to lookup values on the left.

To fetch the values from the left of the reference column.

 

[AlanY]

you can try to use index/match instead

 

[Ruban S]

you can try to use index/match instead

Thank You It works Great.

If possible, please help me with this.

Auto Splitting of Data

Dear, I have data like this SHORT LONG NOUN MODIFIER ATT N1 ATT V1 ATT N2 ATT V2 ATT N3 ATT V3 CHEMICAL,FAST-DRY SELF VULCANIZING CEMNT CHEMICAL, TYPE:FAST-DRY SELF VULCANIZING CEMENT, PACK SIZE:236.6ML CHEMICAL -- TYPE PACK SIZE CHEMICAL,FLUSH,LOCO,236.6ML CHEMICAL,FLUSH...

www.mrexcel.com