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: 154 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
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
16 October 2026
CA article trainee

Zerdi & Co. Chartered Accountants

Pune

CA Inter

View Details
Company
15 October 2026
Senior Accountant

Continental Belting Pvt Ltd

Mumbai

B.Com

View Details
Company
ARTICLESHIP 08 October 2026
ARTICLE TRAINEE

S.B.G. & CO. CHARTERED ACCOUNTANTS

New Delhi

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
08 October 2026
SALES TELECALLER

HIRE NOVA

Lucknow

Graduate (Any)

View Details