+ Reply to Thread
Results 1 to 2 of 2

Index match - replace tab reference

  1. #1
    Registered User
    Join Date
    11-03-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    29

    Index match - replace tab reference

    Hi, I would like to replace the "Rev'!" in the formula below with a reference to the current workbook, Tab A, cell D19 (with the word "Rev" in it. This is so that I can change the lookup to another tab if needed. Can someone pls advice?

    =IFERROR(INDEX(INDIRECT([Database.xlsx]Rev!$C7&"!$A$5:$ZZ$400"),MATCH([Database.xlsx]Rev!$B7,INDIRECT([Database.xlsx]Rev!$C7&"!$A$5:$A$400"),0),MATCH([Database.xlsx]Rev!C$2,INDIRECT([Database.xlsx]Rev!$C7&"!$A$5:$ZZ$5"),0)),"-")

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Index match - replace tab reference

    Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX MATCH with MID or REPLACE
    By Emile du Toit in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-12-2017, 02:29 PM
  2. [SOLVED] using Index match in replace of vlookup
    By srinivasan1965 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2016, 07:58 AM
  3. [SOLVED] How to replace VLOOKUP with INDEX and MATCH
    By jackson_hollon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2014, 04:38 PM
  4. Replies: 4
    Last Post: 01-13-2014, 04:16 AM
  5. Match and replace with index
    By prayami in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-26-2011, 08:51 PM
  6. Replace #N/A using Index Match function
    By karstens in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2006, 03:04 PM
  7. index/match/replace
    By InventoryQueryGuy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-13-2006, 11:10 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1