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: 147 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
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
ARTICLESHIP 28 September 2026
Junior Accountant

J S P M & Associates LLP

Pune

B.Com

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 16 September 2026
CA Article Trainee

SR BAGAI & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
04 September 2026
CA inter Or ca finalist

A Jaiswal and company

Lucknow

CA Final

View Details