Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-25-2015, 10:03 PM
macropod's Avatar
macropod macropod is offline Index/match accross two workbooks Windows 7 64bit Index/match accross two workbooks Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Assuming you've done the referencing correctly, the formula will work BUT you will need the source workbook to be open for the formula to return a result. That's quite possibly why you're getting the "N/A" errors. You can get around that by creating a reference sheet in your target workbook that explicitly references each cell in the source workbook, then point the formula in your target workbook to that new sheet (which can be hidden and protected, if needs be).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Translate INDEX(MATCH) into VBA grexcelman Excel Programming 1 03-08-2015 05:06 PM
Index match vba grexcelman Excel 0 03-05-2015 10:55 PM
Index Match syntax grexcelman Excel Programming 0 03-05-2015 07:17 AM
UDF multiple IFs INDEX-MATCH grexcelman Excel Programming 0 02-22-2015 04:20 PM
Index/match accross two workbooks Index Match function jackzha Excel 5 12-03-2014 12:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft