software

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: www.excelforum.com/member.php...oamp;userid=27206
View this thread: www.excelforum.com/showthread...hreadid=525029Try something like

=OFFSET(B1,MATCH(A1,B1:B10,0),-1)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Weaselquot; gt;
wrote in message
...
gt;
gt; I'm looking for a way to make the lookup formula, or any other
gt; formula
gt; that might work, be directed towards a cell that is one over
gt; and one
gt; down. As an example I know if I use the formula
gt; =VLOOKUP(A1,actuals!B4:C34,2) that it will look vertically to
gt; the right
gt; one cell once it's found what it was looking for. What I'm
gt; looking for
gt; is a way that once it finds what it was looking for to then
gt; look one to
gt; the left and one down.
gt;
gt; Thanks in advance for any help you can offer.
gt;
gt;
gt; --
gt; Weasel
gt; ------------------------------------------------------------------------
gt; Weasel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=27206
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=525029
gt;