| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get information from one sheet to another
I have two data sources and I'm dumping one source onto sheet1 and the other
onto sheet2. I have a common id that is unique in each sheet in column B in each sheet). Sheet1 has all my active and correct id's. Sheet2 has ALL id's wheather they are active or not and also has a value in column BC) I need to fill onto sheet1 somewhere beside the active id. How do I get the value from sheet2 over to sheet1? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get information from one sheet to another
Use VLOOKUP..Refer help
In Sheet1..with unique id in B2...you can try this formula in any of the free cells in row 2. =VLOOKUP(B2,Sheet2!B$1:BC$1000,54,0) If this post helps click Yes --------------- Jacob Skaria "holly2327" wrote: I have two data sources and I'm dumping one source onto sheet1 and the other onto sheet2. I have a common id that is unique in each sheet in column B in each sheet). Sheet1 has all my active and correct id's. Sheet2 has ALL id's wheather they are active or not and also has a value in column BC) I need to fill onto sheet1 somewhere beside the active id. How do I get the value from sheet2 over to sheet1? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get information from one sheet to another
Thank you, this seemed to have worked!
Holly "Jacob Skaria" wrote: Use VLOOKUP..Refer help In Sheet1..with unique id in B2...you can try this formula in any of the free cells in row 2. =VLOOKUP(B2,Sheet2!B$1:BC$1000,54,0) If this post helps click Yes --------------- Jacob Skaria "holly2327" wrote: I have two data sources and I'm dumping one source onto sheet1 and the other onto sheet2. I have a common id that is unique in each sheet in column B in each sheet). Sheet1 has all my active and correct id's. Sheet2 has ALL id's wheather they are active or not and also has a value in column BC) I need to fill onto sheet1 somewhere beside the active id. How do I get the value from sheet2 over to sheet1? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help!! using sheet 1 information to change information on sheet 2 | Excel Worksheet Functions | |||
| checkbox, then taking information from one sheet to another sheet | Excel Worksheet Functions | |||
| Information copying from sheet 1 to sheet 2 | Excel Discussion (Misc queries) | |||
| How do I automatically get information from sheet 1 into sheet 2 | Excel Discussion (Misc queries) | |||
| Reference information from one sheet to a second sheet | New Users to Excel | |||
Linear Mode
