(redirected from Lookup table)
Also found in: Dictionary, Thesaurus, Medical, Legal, Acronyms, Encyclopedia, Wikipedia.


Statistical composite that measures changes in the economy or in financial markets, often expressed in percentage changes from a base year or from the previous month. Indexes measure the ups and downs of stock, bond, and some commodities markets, in terms of market prices and weighting of companies in the index.


A statistical measure of the value of a certain portfolio of securities. The portfolio may be for a certain class of security, a certain industry, or may include the most important securities in a given market, among other options. The value of an index increases when the aggregate value of the underlying securities increases, and decreases when the aggregate value decreases. An index may track stocks, bonds, mutual funds, and any other security or investment vehicle, including other indices. An index's value may be weighted; for example, securities with higher prices or greater market capitalization may affect the index's value more than others. One of the most prominent examples of an index is the Dow Jones Industrial Average, which is weighted for price and tracks 30 stocks important in American markets.


The relative value of a variable in comparison with itself on a different date. Many security price indicators such as the Standard & Poor's series and the New York Stock Exchange series are constructed as indexes. Also called stock index. See also base period.


To adjust a variable by a selected measure of relative value. For example, it has been proposed that an investor's basis on a security be indexed for changes in consumer prices so that only real increases in value will be taxed. Also called tax indexing. See also subindex.


An index reports changes up or down, usually expressed as points and as a percentage, in a specific financial market, in a number of related markets, or in an economy as a whole.

Each index -- and there are a large number of them -- measures the market or economy it tracks from a specific starting point. That point might be as recent as the previous day or many years in the past.

For those reasons, indexes are often used as performance benchmarks against which to measure the return of investments that resemble those tracked by the index.

A market index may be calculated arithmetically or geometrically. That's one reason two indexes tracking similar markets may report different results. Further, some indexes are weighted and others are not.

Weighting means giving more significance to some elements in the index than to others. For example, a market capitalization weighted index is more influenced by price changes in the stock of its largest companies than by price changes in the stock of its smaller companies.


(1) A statistical indicator that measures changes in the economy in general or in particular areas.An example is the cost-of-living index.(2) A reference point against which measurements are taken for purposes of making future adjustments.An adjustable-rate mortgage might begin with an interest rate of 6 percent and provide that it will increase or decrease in a like percentage as the increase or decrease between today's quoted price for 10-year U.S.Treasury bonds and the price on the loan's annual anniversary date.We would say that 10-year T-bonds are the index.

Some leading loan indices include

• Wall Street Journal prime
• Federal discount rate
• Fed funds rate
• 11th District Cost of Funds
• 10-year Treasuries
• One-year LIBOR

References in periodicals archive ?
In the case of triangular lookup table the motor produces the lowest speed at no-load condition.
Four techniques namely direct lookup table, interpolation, table partitioning and co-transformation have been discussed as to compute the addition and subtraction operations.
Destination CC being upgraded, maintained or upgraded, maintained failed or failed Table 2: Lookup Table in self-allocator component Component Name Component ID DIS ID DIS Status Functional Component A FCXXXX DISXXXX Running Functional Component B FCXXXX DISXXXX Not Responding self-monitor CCXXXX DISXXXX Running self-backup-restore CCXXXX DISXXXX Failed Table 3: Task Table in self-backup-restore component CC Name Timestamps Task Task Status self-allocator YYYY-MM-DD-HH:MM:SS Task:T2 Finished self-monitor YYYY-MM-DD-HH:MM:SS Task:T3 Finished self-monitor YYYY-MM-DD-HH:MM:SS Task:T7 Running self-allocator YYYY-MM-DD-HH:MM:SS Task:T9 Not Finished self-backup-restore YYYY-MM-DD-HH:MM:SS Task:T5 Running Table 4.
The next two forms in the workbook use formulas that will rely on two lookup tables.
As soon as you need to divide Revenue from the main table by Quota in the lookup table, you will need the more expensive version of Excel to access the calculation features.
However, these variations can be fine-tuned under the control of analog signals to achieve good constellations, and the corrections then can be stored in a lookup table after calibrating the modulator.
A vertical lookup table is a small database that is easily called up from any cell in the worksheet by means of the @VLOOKUP function of Lotus 1-2-3.
While most lookup tables don't have to be sorted, your table has to be sorted ascending when you use the approximate match VLOOKUP.
30-inch IPS panel and 6-megapixel resolution with wide viewing angles, 1000:1 contrast ratio and 400 cd/mA calibrated brightness (800 cd/mA native resolution), Dual 3-megapixel replacement functionality, Integrated front sensor to maintain calibration for the life of the display, Factory calibration to the DICOM grayscale function for luminance, 16-bit internal lookup table (LUT), which provides for more finely detailed, high-definition rendering of color images and crisper display of even the most delicate shadings, Integrated two port USB 2.
A VLOOKUP would solve the problem, but a typical VLOOKUP would have the worksheet name hard-coded in the lookup table reference: =VLOOKUP("Total Revenue", 'CC 1020'
The summation of two lookup table entries controls each potentiometer.