| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
input # on sheet 1, pulls all info for # from sheet 2
I have two sheets in excel. Sheet #2 has info in A1 through Af, 400 items
listed down, all items have a unique number. When I enter that number in sheet one how do I get it to pull all the info from sheet 2 onto sheet 1? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
input # on sheet 1, pulls all info for # from sheet 2
Use VLOOKUP. It's really simple to set up and once you've got the hang of it you'll wonder how you ever managed to live without it. Until you find INDEX/MATCH of course! ;-) Anyway, send me your book and I'll show you if you like Lee moochx5 wrote: *I have two sheets in excel. Sheet #2 has info in A1 through Af, 400 items listed down, all items have a unique number. When I enter that number in sheet one how do I get it to pull all the info from sheet 2 onto sheet 1? * -- roundabout ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message2361155.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| how to get values from different sheet when info. matches? | Excel Worksheet Functions | |||
| How do I compare info in on sheet to info in another? | Excel Discussion (Misc queries) | |||
| How do I create a total sheet that will pull info from all my she. | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
