#OPENOFFICE COLUMNS IN HEADER HOW TO#

Press Ctrl+x (The Cu t keyboard shortcut) (A through E is deleted in cells F11 through F15) (#N/A is replaced by B in B4 and A in B5.) (The $ sign is inserted into all theĬell names except A1 =LOOKUP(A1 $E$11:$E$15 $F$11:$F$15) Highlight everything in the parenthesis, except A1 It is most practical to place them in adjacent rows or columns.

The Search vector and result_vector can be located anywhere on the spreadsheet and even on different spreadsheets. The data in the result_vector are the page numbers in our book example. The result_vector is a range of cells that correlates to those of the Search vector. LOOKUP compares the Search criterion (the “topic”) to the values in the Search vector to find a match. The Search vector is a range of cells in a row or column and is akin to a book index. The Search criterion is the 'topic' you are looking for. Is a semi-colon “ ” is used to separate the parts of the formulaĪnd the color “:” used to create a range? The formula mightīe written A1 F11:F15 F11:F15 Search Criterion The lookup searches the corresponding cell in the range E11 through E15įor the number entered that will be entered in A1 (Does F11:F15 have any The syntax is: LOOKUP( Search criterion Search vector R esult_vector )Ī later in this tutorial the following LOOKUP will be used Į11:E15 is a range of cells (the five cells are in the E column on rows LOOKUP uses the same principle to retrieve values from a list. What is done is composed of two parts – The word(s) located With books, the book's index is used to find the page where something is Note that the cell A1 does not change and the other four cells increasesĪ1 has 5, A2 has 4, A3 has 3, A4 has 2, and A5 has 1Į11 has 1, E12 has 2, E13 has 3, E14 has 2, and E15 has 1Ī is in F11 B is in F12 C is in F13 D is in F14 E is in F15 (Click on the handle and drag the handle to cell B5) ( E appears in A1, D appears in A2, C appears in A3, and #N/A appears in A4 & A5 )ī1 has the formula =LOOKUP(A1 E1 1:E1 5 F1 1:F1 5)ī2 has the formula =LOOKUP(A1 E1 2:E1 6 F1 2:F1 6)ī3 has the formula =LOOKUP(A1 E1 3:E1 7 F1 3:F1 7)ī4 has the formula =LOOKUP(A1 E1 4:E1 8 F1 4:F1 8)ī4 has the formula =LOOKUP(A1 E1 5:E1 9 F1 5:F1 9) Select B1 again and drag the formula to B5. There is a colon after E11 andį11) (Press Enter for the formula to be accepted)

Įnter 5 in A1, 4 in A2, 3 in A3, 2 in A4, and 1 in A5.

Įnter the letter A in F11, B in F12, C in F13, D in F14, and E in F15.(Click on the handle at the lower, right corner of cell E11, hold the click and drag the handle down to cell E15, then release the click) (Click on cell E11, then press the 1 key (the number one key), then press Enter. There are six different look-up functions in Calc.Ī particular circumstance will determine which particular look-up(s) toįirst you will do an actual LOOKUP then there will be an explanation ofĮnter 1 in Cell E11. If not, do the tutorials in Chapter One of Calc before doing this tutorial.Ĭlick on our website The path to reach Chapter One is: Home Page > Calc One Goal – Many Ways This tutorial assumes that you already have some experience using spreadsheets. Businesses use theĭatabase-like structure of spreadsheets to produce invoices, track inventory,Įstimate costs, or manage budgets all of these tasks require some form Spreadsheets are composed of individual cells that are like separate blocks

#OPENOFFICE COLUMNS IN HEADER HOW TO#

This tutorial explain how to use the Look-Up functions in Calc. Tutorial donated by Wayne Tschirhart Purpose MATCH(search_criterion lookup_array type).V(H)LOOKUP(Search criterion array index sort order).

Openoffice columns in header