Tutorial by Topics: lookup



Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.

The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find.

When processing a given record, you will oft need to retrieve data from one of its related records. For example, when working with a given Sales Order, you may need to retrieve data from the related Sales Rep. In SuiteScript terminology, this is called a lookup.

Lookup functionality is provided by the nlapiLookupField global function in SuiteScript 1.0 and the N/search module's lookupFields method in SuiteScript 2.0


Page 1 of 1