Paramix Learning: Shopping List Using Vlookups

Shopping List using Vlookups

By: Eddie Baki, 20.8.2012, 13:41

This tutorial uses a shopping application to show the way Vlookups are used. All material shown here applies to Excel, Libreoffice and openoffice.

Part 1

The Vlookup requires four parameters:

Search Criterion
This is the element you wish to have looked up

This is your look-up table, your dictionary so to speak

Column number of element you wish returned

Input is either 0 or 1

Does the dictionary contain all elements you wish looked up? Then you enter 0
If the dictionary only contains ranges, then you input 1.

Part 2

Please use the feedback link below for comments and suggestions.

Contact   Feedback   Just Content   Top

Copyright 2016 Paramix e. K.    Contact   Legal Details