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

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