vursee.blogg.se

The HLOOKUP cell will now look up the contents of package 1 from the table as shown below.

Press OK to close window and add the function to the spreadsheet. Enter 2 in the index text box, which is table’s second row. Then select the table cell range for the array. Select HLOOKUP from the window.Ĭlick the button beside the search_criteria text box to select the cell outside the table you entered package 1 in. Select a cell to add the function to, and press the fx button to open the Function Wizard. The table has a horizontal format with the record fields entered in rows.Įnter package 1 in another spreadsheet cell. In a second row beneath that input food, paper and DVDs so that it matches the table in the shot below. In the first row enter package 1, package 2 and package 3 in three cells. However, with HLOOKUP you can look up data in tables that have horizontal layouts.įor example, set up a small table in a Calc spreadsheet with a couple of rows. Calc also has a HLOOKUPfunction that is similar. Another post covered OpenOffice’s VLOOKUP function to look up data with.