LOOKUP in Excel
 

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.

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.

=LOOKUP (C15,a1:a20,B2:b21)

The above will return the value in the adjacent (row+1) cell

http://HelpExcel.com

"JDR" wrote:

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.

Do you always want the value below what the lookup returns?

=INDEX(B1:B20,MATCH(C15,A1:A20)+1)


--

Regards,

Peo Sjoblom


"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.