| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VLOOKUP Range_lookup TRUE
|
|
#2
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
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
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
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plz send me ex for Range_lookup in Vlookup functions | Excel Discussion (Misc queries) | |||
| Hlookup, range_lookup parameter | Excel Worksheet Functions | |||
| VLOOKUP returning value when range_lookup false | Excel Worksheet Functions | |||
| VLOOKUP(lookup_value, ___ ,col_index_num,range_lookup) | Excel Worksheet Functions | |||
| range_lookup in lookup functions | Excel Worksheet Functions | |||
Linear Mode
