If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|