LOOKUP And VLOOKUP Function In Microsoft Excel Or Google Spreadsheet

Basically if you want to lookup and retrieve data from a specific range of column in a table you can either using LOOKUP, VLOOKUP or HLOOKUP. In this article i am going to show you an example of using VLOOKUP.

The syntax of VLOOKUP function as you can see in this example :

=VLOOKUP(B3,D2:E4,2,0)

To make it clear what the above function look on a real spreadsheet with real data,  you can look at this picture below.

What is LOOKUP And VLOOKUP function

VLOOKUP is a Spreadsheet function to lookup and retrieve data from a specific column in table. It supports approximate, exact matching, and wildcards for partial matches.

The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

Spreadsheet program is very useful for doing data processing or data manipulation, because there's support to use functions, we can get specific data from specific cells  using some logic. we can use some spreadsheet functions.

I don't know how to use LOOKUP function to be properly working. So I can't explain it or giving you an example of using LOOKUP function, i think just using VLOOKUP it can substitute the usage of LOOKUP.

To be honest I've never use Lookup function, because it's never work for me, either i am too stupid or i don't know i use VLOOKUP instead, i beleive it’s works the same, only different orientation of the presented data, the one is horizontal the other is vertical.

Comments

Popular posts from this blog

ERROR 1348 Column Password Is Not Updatable When Updating MySQL Root Password

ASUS Battery Health Charging Software To Make Your Battery Life Longer

Is Nox Player a Malware? Nox Android Emulator

How To Uninstall Angular CLI, The Angular Framework

JavaFX Combo Box with Search Autocomplete

Push Notification Cordova, FCM And PHP

How To Create Spring Boot Project Using Netbeans

JavaFX Dialog Material Design

JavaFX Email Validation using JFoenix TextField

Inno Setup Installer Creator For Windows Programs