+ Reply to Thread
Results 1 to 2 of 2

Indirect OR Address OR Index function?

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    DallasTX
    MS-Off Ver
    Excel 2007
    Posts
    40

    Indirect OR Address OR Index function?

    I'm pretty sure this is simple, but I can't figure it out...
    A B C
    Non technical Sales Technical
    1: S1 5000 10000 15000
    2: S2 20000 25000 30000
    3: S3 350000 40000 45000

    If the search criteria is S2 and Sales I want it to return 25000.

    Sorry can't upload the sheet. On work computer.

    Thanks!!

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Indirect OR Address OR Index function?

    Try this one..

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    change the color one to reference like B19, C15.. according to your Work Computer..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 01-13-2013, 08:56 PM
  2. [SOLVED] Using ROW function inside of both an Indirect and Index function returns #VALUE
    By xandermacleod in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-11-2012, 06:22 PM
  3. Trying to replace INDIRECT with INDEX or another function
    By deadlyduck in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2009, 12:51 PM
  4. Moving Down Rows using indirect and address function
    By plitv001 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-02-2008, 01:16 PM

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