Vlookup questions

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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,

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
 
Thanks guys....

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

Thanks again,

Steve
 
Back
Top