Excel: find, copy, paste in good order sheet2
Closed
Kris
-
Sep 24, 2009 at 08:03 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 24, 2009 at 10:20 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 24, 2009 at 10:20 PM
Related:
- Excel: find, copy, paste in good order sheet2
- 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
Sep 24, 2009 at 10:20 PM
Sep 24, 2009 at 10:20 PM
suppose headings are in row no.1 both in sheets1 and 2.
in sheet 2 and in cell F2 copy paste this formula
=VLOOKUP($A2,Sheet1!$A$1:$C$100,COLUMN(A$1),0)
copy F2 both down and across to column H
I do not know why you want the names in column F when this is already available in column A
I suppose the total number of rows is <100 if more change "C100" in the formula suitably
read about vlookup function in excel help . it is extremely useful function
in sheet 2 and in cell F2 copy paste this formula
=VLOOKUP($A2,Sheet1!$A$1:$C$100,COLUMN(A$1),0)
copy F2 both down and across to column H
I do not know why you want the names in column F when this is already available in column A
I suppose the total number of rows is <100 if more change "C100" in the formula suitably
read about vlookup function in excel help . it is extremely useful function