Vlookup questions

[Steve]

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

 

[Eduardo]

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

 

[Ashish Mathur]

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

 

[Mike H]

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]

Thanks guys....

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

Thanks again,

Steve