__

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

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

Index
Column number of element you wish returned

Sorting
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