i need to use vlookup in office to lookup the value from another workbook hw do i do that? thanks
2007-09-24 14:56:46 · 2 answers · asked by elaine_juan81 1 in Computers & Internet ➔ Software
It works the same as in Excel.
=VLOOKUP(Search criterion;array;index;Sort order)
Search criterion is the value searched for in the first column of the array.
array is the reference, which is to comprise at least two columns.
index is the number of the column in the array that contains the value to be returned. The first column has the number 1.
Sort order is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE if the first column is not sorted in ascending order.
2007-09-27 00:11:44 · answer #1 · answered by vbmica 7 · 0⤊ 0⤋
Vlookup In Openoffice
2016-12-11 17:29:21 · answer #2 · answered by sherburne 4 · 0⤊ 0⤋
This Site Might Help You.
RE:
how to use vlookup in openoffice calc?
i need to use vlookup in office to lookup the value from another workbook hw do i do that? thanks
2015-08-06 17:05:04 · answer #3 · answered by Anonymous · 0⤊ 0⤋