OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 334)

Use VLOOKUP when:

• The data is arranged in rows and you want to return data from the same row.

For example, student names with test and quiz scores to the right of the

student’s name.

• Searching the first column of a range of data.

Search a block of data using HLOOKUP

Use HLOOKUP to search the first row (rows are horizontal) of a block of data and

return the value from a row in the same column. HLOOKUP supports the same form

and arguments as VLOOKUP:

HLOOKUP(search_value; search_range; return_row_index)

HLOOKUP(search_value; search_range; return_row_index;

sort_order)

Use HLOOKUP when:

• The data is arranged in columns and you want to return data from the same

column. For example, student names with test and quiz scores underneath the

student’s name.

• Searching the first row of a range of data.

Search a row or column using LOOKUP

LOOKUP is similar to HLOOKUP and VLOOKUP. The search range for the LOOKUP

function is a single sorted row or column. LOOKUP has two forms:

LOOKUP(search_value; search_range)

LOOKUP(search_value; search_range; return_range)

The search value is the same as HLOOKUP and VLOOKUP. The search range,

however, must be a single row or a single column; for example, A7:A12 (values in

column A) or C5:Q5 (values in row 5). If the return_range is omitted, the matched

value is returned. Using LOOKUP without a return range is the same as using

HLOOKUP or VLOOKUP with a column index of 1.

The return range must be a single row or column containing the same number of

elements as the search range. If the search value is found in the fourth cell in the

search range, then the value in the fourth cell in the return range is returned. The

return range can have a different orientation than the search range. In other words,

the search range can be a row and the return range may be a column.

Use LOOKUP when:

• The search data is sorted in ascending order.

• The search data is not stored in the same row, column, or orientation as the

return data.

Use MATCH to find the index of a value in a range

Use MATCH to search a single row or column and return the position that matches

the search value. Use MATCH to find the index of a value in a range. The supported

forms for MATCH are as follows:

=MATCH(search_value; search_range)

=MATCH(search_value; search_range; search_type)

334 OpenOffice.org 3.3 Calc Guide

1 2 ... 329 330 331 332 333 334 335 336 337 338 339 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 334

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3