+ Reply to Thread
Results 1 to 2 of 2

referencing arrays in index and match

  1. #1
    Forum Contributor
    Join Date
    09-19-2007
    Posts
    115

    referencing arrays in index and match

    i'm trying to reference an array (being a column) in index and match formulas, yet rather than have it referenced to the column (eg $D:$D) i'd like to have it referenced to a cell that specifies the column (eg contacted of cell A1 = D, so reference to array is A1:A1).

    I tried the =MATCH(B1,"A1":"A1",0) and =MATCH(B1,&A1:&A1,0) yet neither worked. any suggestions? is this even possible?

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887
    Hello inky,

    Try this instead:

    Please Login or Register  to view this content.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1