Question

(2:15:53 PM) MartinCleaver: here, for a table, and using spreadsheet plugin, how do I do a vlookup?
(2:47:51 PM) MartinCleaver: it's somewhat surprising there is no vlookup, after all its a most commonly used excel function
(2:48:59 PM) Demi: what is this vlookup?
(2:53:22 PM) MartinCleaver: from a grid of two columns, and a value in the left column, a vlookup finds the value in the same row on the right column
(2:53:30 PM) MartinCleaver: v stands for vertical
(2:57:21 PM) Demi: ah okay
(3:11:10 PM) MartinCleaver: any idea how best to do this in TWiki?

Environment

-- MartinCleaver - 12 Oct 2007

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

The SpreadSheetPlugin does not yet have a $VLOOKUP() function. Please feel free to contribute!

Description of vlookup at http://techonthenet.com/excel/formulas/vlookup.php

-- PeterThoeny - 14 Oct 2007