Match data from Master Worksheet

Closed
Rajeev - Aug 31, 2012 at 12:29 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Sep 11, 2012 at 06:00 AM
Hello,

i have two worksheets A & B with different fields but one field is common in both worksheets. I want to get some field from sheet B.
Fields of Sheet A (10 Records)
1. Sr.No
2. Roll No
3. Name
Fields of Sheet B (100 Records)
1. Sr.No
2. Roll No
3. Name
4. F Name
5. Add1
6. Add2
7. City
8. State
9. Pin

I want to match both sheet and get the remaining fields from sheet B to sheet A. Kindly do the needful.

Thanking you

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Sep 11, 2012 at 06:00 AM
have u tired vlookup?
0