Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Posts
    47

    Unanswered: Search for an elements value in a dynamic array.

    Hi,

    Attached is an excel spreadsheet with an array named "Test".

    I would like to find out the value of "m" in a dynamic array with:
    - relative positioning (not hardcoding row and column numbers)
    - using no sub-array names
    - using formula (not VB).

    Is this possible?

    Regards,
    Kashi
    Attached Thumbnails Attached Thumbnails Lookup.JPG  
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •