how to address external sheet as reference

N

NK

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
 
M

Max

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
 
Top