Index/ Match

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 10 Jul 2006 17:31 GMT

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

Reply to this Message

Bob Phillips - 10 Jul 2006 18:26 GMT

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))

Signature

HTH

Bob Phillips

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

> Hi, I am using the following formula to look up records on a worksheet
> within the same workbook:
[quoted text clipped - 5 lines]
> Thanks
> Paul

Reply to this Message