VLOOKUP Range_lookup TRUE
 

Why don't my tests work?

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

http://img525.imageshack.us/img525/5...ookuptest2.gif

VLOOKUP Range_lookup TRUE
 

You have to sort your table ascending.

Regards,
Per


"Pekka Numminen" skrev i meddelelsen
...
Why don't my tests work?

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

http://img525.imageshack.us/img525/5...ookuptest2.gif

VLOOKUP Range_lookup TRUE
 

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.




"Pekka Numminen" wrote:

Why don't my tests work?

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

http://img525.imageshack.us/img525/5...ookuptest2.gif
.

VLOOKUP Range_lookup TRUE
 

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" wrote:

Why don't my tests work?

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

http://img525.imageshack.us/img525/5...ookuptest2.gif
.

VLOOKUP Range_lookup TRUE
 

On 21 Feb, 11:01, "Per Jessen" wrote:
You have to sort your table ascending.

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

VLOOKUP Range_lookup TRUE
 

On 21 Feb, 11:14, trip_to_tokyo wrote:
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?

VLOOKUP Range_lookup TRUE
 

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

"Pekka Numminen" skrev i meddelelsen
...
On 21 Feb, 11:01, "Per Jessen" wrote:
You have to sort your table ascending.

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