The first column is the searched column, so the text Bob is returned. The statement =VLOOKUP('Bob' A1:G9 1) finds the first row in A1:G9 containing the text Bob, and returns the value in the first column.

The return_column_index identifies the column to return a value of 1 returns the first column in the range. For example, B3:G10 searches the same sheet containing the VLOOKUP formula and Sheet2.B3:G10 searches the range B3:G10 on the sheet named Sheet2. The second argument, search_range, identifies the cells to search only the first column is searched. For example, Fred searches for the text Fred, 4 searches for the number 4, and F.* is the regular expression for finding something that starts with the letter F. The search value can be text, a number, or a regular expression. The first argument, search_value, identifies the value to find.

VLOOKUP(search_value search_range return_column_index sort_order) VLOOKUP(search_value search_range return_column_index) For example, search the first column for the name “Fred” and then return the value in the cell two columns to the right. Use VLOOKUP to search the first column (columns are vertical) of a block of data and return the value from another column in the same row. 4 Use MATCH to find the index of a value in a range.

Formulas en openoffice calc