+ Reply to Thread
Results 1 to 2 of 2

Find column number based on text

  1. #1
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106

    Find column number based on text

    I need to look up a text in another workbook. WITHOUT VBA, is there a way to lookup a certain text and return what column number it is in?

    For example:
    A.....B.....C
    HI....YO...WHAT UP


    <lookup "WHAT UP"> Desired results: 3

    The reason I'm doing this is because I have a workbook that will look at various exported data. Sometimes, the column position changes and instead, I want excel to look for the header "amount paid" in the source sheet to give me data.
    This won't be a simple case of HLOOKUP either, because I need to match by header and another row criteria.
    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106
    Got answer on first post:
    =SUMPRODUCT(('[Workbook1.xls]Sheet1'!A1:C100="what up")*(COLUMN('[Workbook1.xls]Sheet1'!A1:C100))
    Kudos to Domenic.

+ 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