Hi

use VLOOKUP
=VLOOKUP(C15,A1:B20,2)

(this requires A1:A20 to be sorted in ascending order)
if you're looking for an exact match with C15 and a value in column A
use the following formula
=VLOOKUP(C15,A1:B20,2,0)
in this case the list does not have to be sorted.

Regards
JulieD


"JDR" wrote in message
...
When I use LOOKUP I get the value returned that I'm looking for. However,
I'm having problems also retrieving the value in the adjacent cell. For
example, lets say my lookup function is:

=LOOKUP(C15,A1:A20,B1:B20)

So, it takes the value in cell C15, finds the closest value in the the
range
A1:A20 (lets say that value is found in A8), and then returns the value
from
B8. How can I also get the value from B9?

Thanks.