LOOKUP Formula help needed

[Weasel]

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.

[Chip Pearson]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>