#1   Report Post  
JDR
 
Posts: n/a
Default 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.

  #2   Report Post  
JulieD
 
Posts: n/a
Default

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.



  #3   Report Post  
galimi
 
Posts: n/a
Default

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

  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how do i get mutiple values using vlookup in excel, lookup value . Abhijeet Excel Discussion (Misc queries) 4 May 19th 05 04:30 AM
lookup multiple occurrences of a value excel ckl Excel Worksheet Functions 5 February 3rd 05 05:19 AM
Lookup Access data in Excel Chris Kellock Excel Worksheet Functions 1 December 28th 04 01:51 PM
Excel Lookup Functions Paul Adams Excel Worksheet Functions 1 November 10th 04 02:40 PM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"