Index/ Match


P

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
 
Ad

Advertisements

B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index Match 1
Index, Match?? 1
index and match 11
Index/Match 5
Index and Match 4
Index Match Functions 1
Match/ Index question 2
Index Match Functions 0

Top