Index/ Match

[Paul]

Hi, I am using the following formula to look up records on a worksheet
within the same workbook:
=INDEX(STUDY,MATCH(1,(Monday!B2=PART)*(Monday!C2=OPS),0))
STUDY, PART and OPS are named ranges.
I would now like to point the formula to look up the data from a different
workbook. All the workbooks are stored on a network. Is this possible?

Thanks
Paul

 

[Bob Phillips]

Paul,

Haven't tested it, but try this

=INDEX('file_path\file_name.xls'!STUDY,
MATCH(1,(Monday!B2='file_path\file_name.xls'!PART)*
(Monday!C2='file_path\file_name.xls'!OPS),0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)