Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2017
    Posts
    1

    Unanswered: INDEX & MATCH w/ workbook & worksheet reference

    I have two workbooks A and B. In workbook A, there are several worksheets, ie: "ABC DE". In this worksheet, there are n number of columns and n number of rows. Column C has certain keys and Column F, G, H has corresonding name values.

    In workbook B, I have some keys that are in column B and worksheet name in column C.

    I want to extract data (column F,G,H) from workbook A into workbook B based on worksheet name and matching key that resides in workbook B. I know index and match function can be used to find matching values but how do I use them in conjunction with referencing a workbook and specific worksheet. Any help is appreciated.

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,101
    Provided Answers: 17
    Sounds like you need the INDIRECT function.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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