+ Reply to Thread
Results 1 to 2 of 2

LOOKUP Formula help needed

  1. #1
    Forum Contributor
    Join Date
    09-13-2005
    Posts
    114

    LOOKUP Formula help needed

    I'm looking for a way to make the lookup formula, or any other formula that might work, be directed towards a cell that is one over and one down. As an example I know if I use the formula =VLOOKUP(A1,actuals!B4:C34,2) that it will look vertically to the right one cell once it's found what it was looking for. What I'm looking for is a way that once it finds what it was looking for to then look one to the left and one down.

    Thanks in advance for any help you can offer.

  2. #2
    Chip Pearson
    Guest

    Re: LOOKUP Formula help needed

    Try something like

    =OFFSET(B1,MATCH(A1,B1:B10,0),-1)


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com



    "Weasel" <Weasel.251imm_1142979001.4716@excelforum-nospam.com>
    wrote in message
    news:Weasel.251imm_1142979001.4716@excelforum-nospam.com...
    >
    > I'm looking for a way to make the lookup formula, or any other
    > formula
    > that might work, be directed towards a cell that is one over
    > and one
    > down. As an example I know if I use the formula
    > =VLOOKUP(A1,actuals!B4:C34,2) that it will look vertically to
    > the right
    > one cell once it's found what it was looking for. What I'm
    > looking for
    > is a way that once it finds what it was looking for to then
    > look one to
    > the left and one down.
    >
    > Thanks in advance for any help you can offer.
    >
    >
    > --
    > Weasel
    > ------------------------------------------------------------------------
    > Weasel's Profile:
    > http://www.excelforum.com/member.php...o&userid=27206
    > View this thread:
    > http://www.excelforum.com/showthread...hreadid=525029
    >




+ 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