Excel: Match data/copy to another worksheet
Closed
Tonya
-
Dec 11, 2011 at 06:12 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 11, 2011 at 08:53 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 11, 2011 at 08:53 PM
Related:
- Excel: Match data/copy to another worksheet
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 11, 2011 at 08:53 PM
Dec 11, 2011 at 08:53 PM
in second sheet in C2 type this formula
=VLOOKUP(B2,Sheet1!$A$1:$B$100,2,0)
and copy it down
if it is more than 100 rows change .
=VLOOKUP(B2,Sheet1!$A$1:$B$100,2,0)
and copy it down
if it is more than 100 rows change .