LOOKUP Formula help needed

[Weasel]

I'm looking for a way to make the lookup formula, or any other formul
that might work, be directed towards a cell that is one over and on
down. As an example I know if I use the formul
=VLOOKUP(A1,actuals!B4:C34,2) that it will look vertically to the righ
one cell once it's found what it was looking for. What I'm looking fo
is a way that once it finds what it was looking for to then look one t
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]...