|
| 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
February 21st, 2010, 08:14 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
February 21st, 2010, 09:01 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
February 21st, 2010, 09:14 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 .
|
|
#4
February 21st, 2010, 09:26 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 .
|
|
#5
February 21st, 2010, 10:21 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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?
|
|
#6
February 21st, 2010, 10:25 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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?
|
|
#7
February 21st, 2010, 10:39 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
