Results 1 to 10 of 10

Find cell address reference for index and match to create use OFFSET for next column

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2014
    Location
    Barnsley, England
    MS-Off Ver
    Excel 2003
    Posts
    26

    Find cell address reference for index and match to create use OFFSET for next column

    I want to use the cell address reference for index and match to create an OFFSET formula to obtain the cell value in the next column for a calculation. Please see attached spreadsheet, cell references are filled "yellow".

    =CELL("address",INDEX($Q$14:$Z$30,MATCH($C$4,$H$14:$H$30,0),1))

    Tried various formula and can't work it out.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] OFFSET+ INDEX-MATCH to find first non-zero column
    By Ztv in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-04-2014, 01:51 PM
  2. Replies: 6
    Last Post: 09-09-2014, 02:25 PM
  3. [SOLVED] Find cell address of dates listed in column based on match
    By jprlimey in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-01-2014, 12:19 AM
  4. Index match offset to get subsequent index values in a column
    By Andrew_Step in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2013, 02:55 PM
  5. [SOLVED] OFFSET a cell address from a match result
    By Solidstan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2013, 04:04 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