| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to address external sheet as reference
hi i have a sheet that include job name and some relevent columns to it, now
i want to use new sheet where i just enter refernece to Job name and then I want Other column should be automatically taken form that sheet...please help me ...URGENT....please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to address external sheet as reference
What you're after here could be done using either VLOOKUP or INDEX/MATCH
provided there's unique values in a key* col which is common to both sheets, eg: JobName in your case *which could be used in matching Suggest you take time to browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NK" wrote: hi i have a sheet that include job name and some relevent columns to it, now i want to use new sheet where i just enter refernece to Job name and then I want Other column should be automatically taken form that sheet...please help me ...URGENT....please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| External cell references using INDIRECT & ADDRESS | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Relative reference to a cell on a previous sheet | Excel Discussion (Misc queries) | |||
| Dynamic reference to a sheet | Excel Worksheet Functions | |||
Linear Mode
