Can my formula get values from two workbooks

I have the following forumula (Lookup) that does exactly what I need but was wondering if the same formula can do the lookup to a different workbook?

=IF(ISERROR(OFFSET(mapping!$A$1,MATCH(A133,mapping!A:A,0)-1,0)),"N/A",OFFSET(mapping!$B$1,MATCH(A133,mapping!A:A,0)-1,0))
Matt PinkstonAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
0
 
Matt PinkstonAuthor Commented:
it is two separate workbooks, the one I want to read is called xref.xls tab sheet1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.