Manual

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

VLOOKUP, the table

entdes must be

sorted in ascending

order.

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,B3: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