+ Reply to Thread
Results 1 to 4 of 4

INDEX/MATCH Across Workbooks

Hybrid View

SamuelT INDEX/MATCH Across Workbooks 01-17-2007, 11:28 AM
Carim Hi, Yes ... both functions... 01-17-2007, 11:34 AM
SamuelT Thanks Carim - turns out the... 01-17-2007, 01:01 PM
Carim Glad you managed to fix your... 01-17-2007, 02:00 PM
  1. 01-17-2007, 11:34 AM #1
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Yes ... both functions can be used across worksheets ..., and opened workbooks ...
    Your formula is correct ...
    Just make sure the file name is correct ...
    Rohma''s tracker SNI.xls
    HTH
    Carim


    Top Excel Links
    Reply With QuoteRegister To Reply
  2. 01-17-2007, 01:01 PM #2
    SamuelT is offline
    Valued Forum Contributor
    Join Date
    09-23-2005
    Location
    Bristol, UK
    MS-Off Ver
    2007
    Posts
    664
    Thanks Carim - turns out the problem was actually in the LEFT(B15,5) part...it should of been LEFT(B15,5)&"*" - now everything is working nicely.

    Cheers,

    SamuelT
    Reply With QuoteRegister To Reply
  3. 01-17-2007, 02:00 PM #3
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Glad you managed to fix your problem ...

    Thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1