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
14 October 2026
GST & TDS ASSISTANT

AGGARWAL SANJAY & ASSOCIATES

New Delhi

B.Com

View Details
Company
12 October 2026
AUDIT , ACCOUNTS AND TAXATION

KDSS

New Delhi

B.Com

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
06 October 2026
Assistant Manager - Audit and Compliance

Ravi K Jain & Co

Noida

Others

View Details
Company
14 October 2026
Accountant

Rize.farm

Bengaluru

B.Com

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
10 October 2026
Accounts Associate Level 1

Abic and Mani Chartered Accountants

Kottayam

B.Com

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details