Consulting

Results 1 to 3 of 3

Thread: Solved: Problem with INDEX , MATCH

  1. 01-11-2006, 01:13 PM #1
    Pizzafiend
    Pizzafiend is offline
    VBAX Regular
    Joined
    Nov 2005
    Posts
    17
    Location

    Solved: Problem with INDEX , MATCH

    Greetings everyone,
    For some reason I have an index match formula using named ranges that will not match correctly. I have attached a sample of the problem. Any help would be greatly appreciated. I use the same formula referencing a different sheet and it works fine.
    Reply With Quote Reply With Quote
  2. 01-11-2006, 02:59 PM #2
    austenr
    austenr is offline
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    MATCH needs a 1Xm table (that is, a horizontal or vertical reference) not a named range
    Peace of mind is found in some of the strangest places.
    Reply With Quote Reply With Quote
  3. 01-11-2006, 05:01 PM #3
    Shazam
    Shazam is offline
    VBAX Expert Shazam's Avatar
    Joined
    Sep 2005
    Posts
    530
    Location
    You can use a non-array formula.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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