Results 1 to 6 of 6

Matching Row# to Cells with multiple Data

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Matching Row# to Cells with multiple Data

    I am building an index function with some success, but I need to find a way to use the MATCH formula (or something similar) to give a row#, however some cells contain multiple values.

    (Our purchase orders are 7 digits long.)
    So, for example

    Purchase Order Column
    1: 1521234
    2: 1731248
    3: 1951254
    1551266
    4: 1256478

    Say I need it to find 1551266, how can I get it to return "3" to indicate which row it is in?

    Let me know if any further explanation is needed. Thanks!
    Last edited by rusty_J; 02-23-2011 at 03:06 PM. Reason: Clarification

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