(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)
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 calculate time difference 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).