+ Reply to Thread
Results 1 to 6 of 6

Index Match Type Mismatch Error

  1. #1
    Registered User
    Join Date
    12-15-2019
    Location
    Rhode Island
    MS-Off Ver
    Excel 2019
    Posts
    7

    Index Match Type Mismatch Error

    Hey guys,

    So I am new to VBA and I am working on one of my first macros. I am attempting to perform an Index Match referencing ranges that I have already established but I am getting a "Type Mismatch" error.

    Please Login or Register  to view this content.
    "Variances" and "AbsValues" are both dimmed as ranges.

    Thanks for your help!
    Attached Files Attached Files
    Last edited by VBAJim; 12-15-2019 at 10:28 PM.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,518

    Re: Index Match Type Mismatch Error

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    12-15-2019
    Location
    Rhode Island
    MS-Off Ver
    Excel 2019
    Posts
    7

    Re: Index Match Type Mismatch Error

    Quote Originally Posted by bakerman2 View Post
    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Sorry about that. I have attached the file. The end goal is to return the n largest variances from the variances column. For the Index Match I am struggling with I am attempting to return the original variance from the absolute values of the variances.

    Thanks!

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,518

    Re: Index Match Type Mismatch Error

    Change this

    Please Login or Register  to view this content.
    to this

    Please Login or Register  to view this content.
    and check if this works for you.

  5. #5
    Registered User
    Join Date
    12-15-2019
    Location
    Rhode Island
    MS-Off Ver
    Excel 2019
    Posts
    7

    Re: Index Match Type Mismatch Error

    Quote Originally Posted by bakerman2 View Post
    Change this

    Please Login or Register  to view this content.
    to this

    Please Login or Register  to view this content.
    and check if this works for you.
    Works like a charm. Thank you!

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,518

    Re: Index Match Type Mismatch Error

    You're welcome and thanks for rep+.

+ 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. "Type Mismatch" Error using Index Function
    By Jenn68 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2019, 04:13 PM
  2. [SOLVED] RunTime Error 13 ( type mismatch ) error is comming TextboxAfter_Update
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-04-2017, 03:55 AM
  3. [SOLVED] Why does Application.Match return "Run-Time error '13': Type mismatch ?
    By Gryfphon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-30-2016, 07:50 PM
  4. [SOLVED] Index/Match lookup with two columns - Runtime Type 13 Error
    By connor12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-17-2014, 09:52 PM
  5. Conditional Formatting - Run Time Error '13' Type Mismatch Error
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2011, 07:37 PM
  6. Type Mismatch Error on Find Closest Match
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2007, 11:07 AM
  7. Help: Compile error: type mismatch: array or user defined type expected
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2005, 05:05 PM

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