Excel worksheet help
Solved/Closed
Shams
-
Jun 26, 2009 at 05:23 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 26, 2009 at 08:07 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 26, 2009 at 08:07 PM
Related:
- Excel worksheet help
- Transfer data from one excel worksheet to another automatically - Guide
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 26, 2009 at 08:07 PM
Jun 26, 2009 at 08:07 PM
I am not sure there are any provision to post a sheet in this forum
let us see
sheet 1 has part no. in column A and data for each part no. in column B to G (row 1 is column headings)
in sheet 2 the cells A2 down have validation list (of part nos. in sheet 1).-here also row 1 has column headings.
in B2 of sheet 2 type this formula (including dollar signs)
=VLOOKUP($A2,Sheet1!$A$1:$G$500,COLUMN(B1),FALSE)
now copy this formula down and to the right .(in the rows where validation list is there)
Initially the entries in the cells except column A of sheet 2 will have #N/A error values. don't bother.
now once you enter any value in for e.g. A2 item from the validation list automatically the other data for this part no. will be available in row 2 of sheet2.
POST FEEDBACK
let us see
sheet 1 has part no. in column A and data for each part no. in column B to G (row 1 is column headings)
in sheet 2 the cells A2 down have validation list (of part nos. in sheet 1).-here also row 1 has column headings.
in B2 of sheet 2 type this formula (including dollar signs)
=VLOOKUP($A2,Sheet1!$A$1:$G$500,COLUMN(B1),FALSE)
now copy this formula down and to the right .(in the rows where validation list is there)
Initially the entries in the cells except column A of sheet 2 will have #N/A error values. don't bother.
now once you enter any value in for e.g. A2 item from the validation list automatically the other data for this part no. will be available in row 2 of sheet2.
POST FEEDBACK