Solved

Can my formula get values from two workbooks

Posted on 2013-01-14
3
137 Views
Last Modified: 2013-02-03
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
Comment
Question by:Matt Pinkston
3 Comments
 
LVL 5

Expert Comment

by:LazyFolk
ID: 38774211
0
 

Author Comment

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

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 38774220
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

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

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

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now