Comparing partial data , get full data

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.

 


Attached File : 42215 1177209 sample data.xlsx downloaded: 138 times
Replies (2)

see attached file.

THANK U VERY MUCH , SHAILESH JI.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
22 July 2026
Senior Chartered Accountant

SKSS

Patna

CA

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
ARTICLESHIP 28 July 2026
Article/Intern/Semi-Qualified/Fresher B.Com

VNSS & Co

Mumbai

Others

View Details
Company
06 July 2026
Accountant

Agarwal Anoop and Associates

Noida

CA Final

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
Featured 18 July 2026
Senior Manager- Finance & Accounts

apricus india

Ahmedabad

CA

View Details
Company
Featured 16 July 2026
Semi Qualified Company Secretary

Vakilsearch.com

Chennai

CS

View Details
Follow