Comparing partial data , get full data

satya (Executive Excise) (1839 Points)

22 May 2013  

Dear Excel experts,

Please find enclosed sample file and  give me a formula to my problem;

my data having in 2 sheets, sheet 2 having partial data,

I need full data from sheet1  to sheet2 by matching 1st five letters with sheet2 data.