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.
see attached file.
Rahul Dang & Associates-Chartered Accountants
Pune
CA Inter
View Details
CMNITY HIRE
New Delhi
Others
View Details
R P S K & Associates
Nashik
CA Inter
View Details
CAclubindia
