Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Urgent VLOOKUP HELP? Don't even know if this is what I need
OK I have two worksheets in one excel spreadsheet. both different info but
some info is the same with each other like name of person but different sales $ amount..anyway I need to merge both into one worksheet the names to match etc..is this when the vlook up comes in place?? I can copy and paste but that's going to take me years LOL its a huge list! Thank you so much - I don't even know where to begin with this -- 2 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Urgent VLOOKUP HELP? Don't even know if this is what I need
Hi
Assuming Sheet1 has the data you wish to extract to Sheet2, and column A on both Sheets contains the name of the person. Assuming the data on Sheet1 extends from column A to Column H. On sheet2 in an empty column to the right of any existing data, enter =VLOOKUP($A1,Sheet1!$A:$H,X,0) where X is the column number of the data you wish to extract. So if Sales is in column C of Sheet1, then =VLOOKUP($A1,Sheet1!$A:$H,3,0) -- Regards Roger Govier "Excel ??" wrote in message ... OK I have two worksheets in one excel spreadsheet. both different info but some info is the same with each other like name of person but different sales $ amount..anyway I need to merge both into one worksheet the names to match etc..is this when the vlook up comes in place?? I can copy and paste but that's going to take me years LOL its a huge list! Thank you so much - I don't even know where to begin with this -- 2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Urgent VLOOKUP HELP? Don't even know if this is what I need
I know this may be a piece of cake to you or anyone here but I just can't
figure this out I have two worksheets, I want to create a master one with both integrated - both worksheets have same persons name like example - worksheet 1 column A has peoples names - then worksheet 2 colum c has same peoples name like these Worksheet 1 (this has a name) Worksheet 2 (this has name too) Colum A Column C 1.Name 1. Name 2 John Doe 2. John Doe But obviously in different order with different info except name I want to match the names on each column to ONE WHOLE spreadsheet does that make sense? -- 2 "Roger Govier" wrote: Hi Assuming Sheet1 has the data you wish to extract to Sheet2, and column A on both Sheets contains the name of the person. Assuming the data on Sheet1 extends from column A to Column H. On sheet2 in an empty column to the right of any existing data, enter =VLOOKUP($A1,Sheet1!$A:$H,X,0) where X is the column number of the data you wish to extract. So if Sales is in column C of Sheet1, then =VLOOKUP($A1,Sheet1!$A:$H,3,0) -- Regards Roger Govier "Excel ??" wrote in message ... OK I have two worksheets in one excel spreadsheet. both different info but some info is the same with each other like name of person but different sales $ amount..anyway I need to merge both into one worksheet the names to match etc..is this when the vlook up comes in place?? I can copy and paste but that's going to take me years LOL its a huge list! Thank you so much - I don't even know where to begin with this -- 2 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Urgent VLOOKUP HELP? Don't even know if this is what I need
Hi
I'm sorry, but I am not following what you are trying to achieve. Do you want to send me a sample workbook? To mail direct roger at technology4u dot co dot uk Change dot and at to make valid address. -- Regards Roger Govier "Excel ??" wrote in message ... I know this may be a piece of cake to you or anyone here but I just can't figure this out I have two worksheets, I want to create a master one with both integrated - both worksheets have same persons name like example - worksheet 1 column A has peoples names - then worksheet 2 colum c has same peoples name like these Worksheet 1 (this has a name) Worksheet 2 (this has name too) Colum A Column C 1.Name 1. Name 2 John Doe 2. John Doe But obviously in different order with different info except name I want to match the names on each column to ONE WHOLE spreadsheet does that make sense? -- 2 "Roger Govier" wrote: Hi Assuming Sheet1 has the data you wish to extract to Sheet2, and column A on both Sheets contains the name of the person. Assuming the data on Sheet1 extends from column A to Column H. On sheet2 in an empty column to the right of any existing data, enter =VLOOKUP($A1,Sheet1!$A:$H,X,0) where X is the column number of the data you wish to extract. So if Sales is in column C of Sheet1, then =VLOOKUP($A1,Sheet1!$A:$H,3,0) -- Regards Roger Govier "Excel ??" wrote in message ... OK I have two worksheets in one excel spreadsheet. both different info but some info is the same with each other like name of person but different sales $ amount..anyway I need to merge both into one worksheet the names to match etc..is this when the vlook up comes in place?? I can copy and paste but that's going to take me years LOL its a huge list! Thank you so much - I don't even know where to begin with this -- 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching data from three columns (VLOOKUP, HLOOKUP, etc...)-URGENT | Excel Worksheet Functions | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
Urgent Dynamic Range with Vlookup | Excel Discussion (Misc queries) | |||
Urgent please | Excel Discussion (Misc queries) |