+ Reply to Thread
Results 1 to 4 of 4

Using OFFSET function to return the value from another cell with row and column offset

  1. #1
    Registered User
    Join Date
    04-26-2014
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    13

    Using OFFSET function to return the value from another cell with row and column offset

    Hello,

    I am having some difficulties using a combination of IF and the OFFSET function to display a range of cell values from another column based on a simple condition. The values I need to display at the destination cells should be offset by 8 columns to the right and "X" rows down from the reference column. The value "X" is to be determined via the IF function to check for the row index number.

    For example, if Index value "X" = 8, then display the value of B2 in cell I9. IF X = "9", display B2 in cell I10 etc.

    I have attached a sample worksheet that provides some examples.

    Thank you for your help.

    Regards
    engine44
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    668

    Re: Using OFFSET function to return the value from another cell with row and column offset

    So, I'm not exactly sure where you want each column looking for the index, but I made a show at what you're asking for. You can do it with index, offset, or indirect. I chose to show you offset and index. If you're every using an external reference, only index works.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-26-2014
    Location
    singapore
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Using OFFSET function to return the value from another cell with row and column offset

    Hello K64,

    This is exactly what I was trying to achieve. Thank you for both options. I also made a slight refinement to the OFFSET solution to get rid of the header since it is a non-data line.



    Regards
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    668

    Re: Using OFFSET function to return the value from another cell with row and column offset

    Good idea. Glad I could help.

+ 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. [SOLVED] If Cell in column = "Y" then with offset (0, 1).value match to sheet range A3:A return ...
    By Spyderz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2012, 02:00 PM
  2. function similar to offset to offset the offset
    By Jerseynjphillypa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2012, 03:07 PM
  3. Reformatting - insert formula with offset, then offset to next cell
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2011, 05:41 AM
  4. How to return multiple column array without using Offset function?
    By agarwaldvk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-27-2008, 04:20 AM
  5. offset 1 row and return to first column
    By GregM in forum Excel General
    Replies: 1
    Last Post: 03-30-2006, 08:45 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