Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default Vlookup questions

Table (leftmost) must be in ascending order. Then is it correct that you
cannot use the same table to look for a different value in a different column
?
Also, if it is not in ascending order, is it true that some of the values
may still be correct, but some are incorrect.

Thanks,

Steve

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default Vlookup questions

Hi Steve,
with vlookup it's true, but you have other options to look for values or
text like sumproduct, index and match, where you don't need to have
evertything in the leftmost column or ordered in ascending order look at
Debra web it will give an idea or the other options

http://www.contextures.com/xlFunctions03.html

http://www.contextures.com/xlFunctions05.html

If this was helpful please click Yes. thanks



"Steve" wrote:

Table (leftmost) must be in ascending order. Then is it correct that you
cannot use the same table to look for a different value in a different column
?
Also, if it is not in ascending order, is it true that some of the values
may still be correct, but some are incorrect.

Thanks,

Steve

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default Vlookup questions

Hi,

Use 0 as the last argument of the VLOOKUP() function - If you use a 0, then
you do not need to ensure that the first column be in ascending order.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Steve" wrote in message
...
Table (leftmost) must be in ascending order. Then is it correct that you
cannot use the same table to look for a different value in a different
column
?
Also, if it is not in ascending order, is it true that some of the values
may still be correct, but some are incorrect.

Thanks,

Steve

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Vlookup questions

Steve,

When using Vlookup there is an optional switch of TRUE/FALSE as the last
argument of the formula. TRUE finds a near match if there is no exact match
and for this to work correctly the leftmost column must be sorted. If FALSE
is specified then then the column need not be sorted.

If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.

Miike


"Steve" wrote:

Table (leftmost) must be in ascending order. Then is it correct that you
cannot use the same table to look for a different value in a different column
?
Also, if it is not in ascending order, is it true that some of the values
may still be correct, but some are incorrect.

Thanks,

Steve

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default Vlookup questions

Thanks guys....

I think that false statement is going to work just fine.

Thanks again,

Steve

"Mike H" wrote:

Steve,

When using Vlookup there is an optional switch of TRUE/FALSE as the last
argument of the formula. TRUE finds a near match if there is no exact match
and for this to work correctly the leftmost column must be sorted. If FALSE
is specified then then the column need not be sorted.

If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.

Miike


"Steve" wrote:

Table (leftmost) must be in ascending order. Then is it correct that you
cannot use the same table to look for a different value in a different column
?
Also, if it is not in ascending order, is it true that some of the values
may still be correct, but some are incorrect.

Thanks,

Steve

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
Two vlookup questions D.Jessup Excel Worksheet Functions 5 October 3rd 08 01:38 PM
VLOOKUP questions Noncentz303 Excel Worksheet Functions 5 May 11th 07 06:38 PM
Vlookup and few more questions :) [email protected] Excel Worksheet Functions 9 October 3rd 06 12:19 AM
VLOOKUP - 2 Questions Kathy - Lovullo Excel Worksheet Functions 1 April 14th 06 08:22 PM
VLOOKUP Questions nyys Excel Worksheet Functions 4 January 5th 06 03:41 PM


All times are GMT +1. The time now is 07:22 AM.

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

About Us

"It's about Microsoft Excel"