Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Can my formula get values from two workbooks

Posted on 2013-01-14
Medium Priority
158 Views
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))
0
Question by:Matt Pinkston
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions

LVL 5

Expert Comment

ID: 38774211
0

Author Comment

ID: 38774218
it is two separate workbooks, the one I want to read is called xref.xls tab sheet1
0

LVL 53

Accepted Solution

Rgonzo1971 earned 2000 total points
ID: 38774220
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilâ€¦
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
###### Suggested Courses
Course of the Month11 days, 6 hours left to enroll

#### 636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.