eqvorti.blogg.se

• OPENOFFICE SUM COLUMN HOW TO

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 SUM COLUMN 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).