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

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"
wrote in message
...

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