![]() |
#2
|
||||
|
||||
![]()
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] |
|
![]() |
||||
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 |
![]() |
jackzha | Excel | 5 | 12-03-2014 12:43 PM |