| http://www.w3.org/ns/prov#value | - As with the LOOKUP function, the advantage of HLOOKUP is that it does not necessarily have to find the exact LOOKUP_VALUE. If, for example, you wanted to find out what interest rate is applicable to a ??28000 loan, the figure 28000 can be entered in the LOOKUP_VALUE cell (A51) and the rate 14.30% appears.
|
