Table of Contents
Advertisement
Information
Function
example:
HLOOKUP
HLOOKUP and VLOOKUP allow you to search for a value that is within a
range of values.
The table below
is an example
of a simple
lookup
table.
This table
tracks a
discount
rate, which
is based
on the number
of units sold.
If you want
to
look up a discount
rate for 1257 units sold,
use HLOOKUP
to extract
values
horizontally.
When using
HLOOKUP
or
VL OOKUP, the table
entdes must be
sorted in ascending
order.
I
2
3
4
5
5
7
R
I e Ic In
i
i
!
i °il®i5ooi
i i i
IEI
r isl
i
i
!
!
|
;
;
;
,
i
i
t,0® i I_®0
i
i
i
i
!
i
i
i
i
i
i
i
!
i
i
HLOOKUP(B1, B 3:F4,1) = 10%,
In this example,
HLOOKUP(B1,B3:F4,1)
returns
10%.
B1 contains
the value,
1257 units.
BI:F4 is the table
range.
The offset is 1, which
defines
the row
containing
information
to search.
In this case the offset is the row with the
discount
rates.
The offset
of the f'n-st row of data
is 0.
HLOOKUP
returns
10%_because
it is the discount
rate for 1,000 to 9,999 units
.
..
u
--_--_<
....J
s0ld.
---
_.
Appendix
219
Advertisement
Table of Contents
