+ Reply to Thread
Results 1 to 4 of 4

Array based on a formula

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2007
    Posts
    79

    Array based on a formula

    Hi,

    I have what I guess is an easy problem for people here. I am trying to define an array based on a formula, but I am not successful so far.

    Let say that I want to write a MATCH formula, looking for a match between column A and D, but for a row which is a variable. How should I declare something like An:Dn, with n=ROW() ?
    Array.xlsx

    Thank you,
    Guillaume

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Array based on a formula

    Try

    =MATCH(F2,INDEX(A:D,n,0),0)

    where n is your variable row #.

  3. #3
    Registered User
    Join Date
    10-17-2011
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2007
    Posts
    79

    Re: Array based on a formula

    Thanks a lot!

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Array based on a formula

    You're welcome.

+ 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