+ Reply to Thread
Results 1 to 2 of 2

Offset, Address & Match

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    1

    Offset, Address & Match

    Mod. edit: below originally posted on thread: http://www.excelforum.com/excel-gene...ml#post2553091

    sir,

    i have to display from matched cell it must display -1 row -2,-1,0,1,2 columns cells for example

    8419 8428 8838 9288 9691
    8262 8136 8660 8987 9603
    8516 8558 8672 9212 9647
    8656 8624 8875 9317 9687
    8361 8365 8625 9028 9083
    8414 8440 8798 8697 8864
    8202 8500 8539 8667 9062
    7367 7631 7771 8117 8287

    7771 is matched cell results must be
    8202 8500 8539 8667 9062
    please provide me formula
    Last edited by DonkeyOte; 06-28-2011 at 03:15 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Combining offset, address, and match

    veeru_php,

    Welcome to the board however please note:

    1. questions should not be posted in the threads of other members. If you have a question to ask please create your own thread. If you feel another thread is particularly relevant to your own problem provide a link to that thread within your post.

    2. do not post the same question repeatedly.


    Given these posts represent your first involvement with the board I will on this occasion correct your posts accordingly and create a thread for you. Going forward please be sure to adhere to the Board Rules when posting (to which you agreed upon registration)
    Last edited by DonkeyOte; 06-28-2011 at 03:22 AM. Reason: typo

+ 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