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 :


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.

Popular posts from this blog

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

Spring Kafka - how to use ReplyingKafkaTemplate send and reply synchronously

How To Connect SSH Using PEM Certificate On Windows

Upload and Download Rest API using Spring Boot Reactive WebFlux

MIME Types - Complete List