P
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Per Jessen
You have to sort your table ascending.
Regards,
Per
Regards,
Per
T
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.
Appl
- in cell D1 when you should have:-
Apple
Please hit Yes if my comments have helped.
T
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.
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.
P
Pekka Numminen
You have to sort your table ascending.
Why? Shouldn't Excel look for the closest number? What is the logic?
P
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?
P
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
table is sorted ascending (small to large). If you do not sort ascending,
you will never get it working... (see excel help file)
Per