VLOOKUP Range_lookup TRUE

[Pekka Numminen]

Why don't my tests work?

http://img716.imageshack.us/img716/4035/vlookuptest.gif

http://img525.imageshack.us/img525/5245/vlookuptest2.gif

 

[Per Jessen]

You have to sort your table ascending.

Regards,
Per

 

[trip_to_tokyo]

Image 525 does not work because you have got:-

Appl

- in cell D1 when you should have:-

Apple

Please hit Yes if my comments have helped.

 

[trip_to_tokyo]

Image 716 does not work because:-

1. You are looking for a value (15 in cell D1 that does not exist in range A
1 to B 5).

2. Your formula in cell F 1 appears to be wrong; it should be:-

=VLOOKUP(D1,A1:B5,2,FALSE)

With the above in cell F1 entry of any of 50 / 40 / 30 / 20 / 10 into cell
D1 will return the correct text in F1.

Please hit Yes if my comments have helped.

Thanks.

 

[Pekka Numminen]

You have to sort your table ascending.

Why? Shouldn't Excel look for the closest number? What is the logic?

 

[Pekka Numminen]

Image 525 does not work because you have got:-

Appl

 - in cell D1 when you should have:-

Apple

The idea of the value TRUE of Range_lookup is to find the closest
match. "Medla" works, so why not "Appl"? Can somebody explain the
logic?

 

[Per Jessen]

Excel does look for the closest number, but the function require that the
table is sorted ascending (small to large). If you do not sort ascending,
you will never get it working... (see excel help file)

Per