+ Reply to Thread
Results 1 to 2 of 2

problem with offset function

  1. 04-05-2007, 11:05 AM #1
    matpj
    matpj is offline
    Forum Contributor
    Join Date
    03-14-2005
    Posts
    164

    problem with offset function

    Hi guys and girls,

    I am trying to use an OFFSET function to lookup a value in one column, find its match on another sheet, and then return the value that is 5 columns to the right of that match.

    my formula:
    Please Login or Register  to view this content.
    I am putting this formula in U6 on the 'Holding Cell' worksheet
    Column A in the sheet 'Project Schedule ETC' has a list of project numbers that should contain a match to the value in T6
    The formula just returns 0 no matter what I change the '5' to..

    can anybody suggest what is wrong with this..

    thanks in advance,
    Matt
    Last edited by matpj; 04-05-2007 at 11:08 AM.
    Reply With QuoteRegister To Reply
  2. 04-05-2007, 11:39 AM #2
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,699
    You need to subtract 1 from the MATCH, i.e.

    =OFFSET('Project Schedule ETC'!A1,MATCH('Holding Cell'!T6,'Project Schedule ETC'!A:A,0)-1,5)

    although I think using INDEX would probably be preferable

    =INDEX('Project Schedule ETC'!E:E,MATCH('Holding Cell'!T6,'Project Schedule ETC'!A:A,0))
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1