HOW TO USE VLOOKUP IN EXCEL / VLOOKUP TUTORIAL

HOW TO USE VLOOKUP IN EXCEL

Vlookup formula is one of the important formula in MS EXCEL. In this blog I will give you clear demonstration about  Vlookup formula. 

Where we use

Sometime we need to find data from a huge list in excel. If we find one or two data then find using ctrl+f and find it, here it is the best method. But if we find more data then we go for Vlookup. If you prepare bill using excel then Vlookup is the best policy.

How to use 

I will explain it step wise. Lets follow.

Step 1. 

Suppose I have a chart of Building Materials with cost / units. And I want to make a bill. Here I take a chart from column A to D and a simple bill format from column G to L. 

how to use vlookup in excel 2016

Step 2.

How it will be if we just type the name of material and the cost and unit will appear automatically !! Lets do it. In the Cost cell means for "J3" type "=vlookup(" then it prompts for "lookup_value", "table_array","col_index_num","[range_lookup]".

how to use vlookup in excel 2016

Step 3.

First for "lookup_value" select cell H3 press " , " for "table_array" select B3 to D7 press " , " next for 
"col_index_num" select the no of column where the cost is here no is 2 because in the selected table cost row is in no 2 column and press " , ".
Then "[range_lookup]" comes here two option available "True" or "False". "True" is for approximate match and "False" is for exact match, we need exact match so we type "false" or "0" as you wish.
Close the Bracket and press "Enter".

how to use vlookup in excel 2016

Step 4.

Oh my god !! its shows error... Don't panic it shows error because H3 cell is empty which is the reference cell for this formula.
Lets put any of the item name from chart and check.
Here I put Bricks, See its shows the Cost 8.5. 


vlookup tutorial

vlookup tutorial


Step 5.

If we put Vlookup formula again as for unit the unit will also be shown. The formula will be as follows "=VLOOKUP(H3,B3:D7,3,0)" See it shows.

vlookup tutorial

Step 6.

For Total Column simple multiply Quantity cell and Cost Cell with "=I3*J3" this formula and hit enter. If you put the value in Quantity Cell It will shows how much the Total is.

vlookup tutorial

Step 7.

For next item just drag down the formula cell or copy the formula cell to next cell .

vlookup tutorial


Conclusion :-

Here I give you total demonstration how Vlookup formula works and implement in a simple bill. If you have any quarries comment me bellow. If you like the article please shear it and thus support me. Thanks. 

Comments

Post a Comment

Popular posts from this blog

STACK MEASUREMENT OF BUILDING MATERIALS

Image
STACK MEASUREMENT OF BUILDING MATERIALS [ এই আর্টিকেল টি বাংলায় পড়তে চান এইখানে  ক্লিক করুন   ] What is  Stack Measurement of Building Materials ? How is it works ?  OK  many question arises in mind when we read the tropic name. Let me clear one by one.  Measurement of Building materials is important for knowing the volume of materials. Instead of measuring building materials we not sure that how much materials we want to buy or ordered and how much materials we received. There are many materials used to construct a structure, out of them few materials are stored in  Stacks. So first we identify which materials can be stored in stacks.  Materials Stored in Stacks Fine sand, Medium Sand , Various types of Stone chips , Moorum, Gravel, Bricks etc. can be stored as stack. Out of them bricks stacks are different type. I explain bricks stack in another blog. How Stacks are Looked Many of us noticed sand, stone ch...
Read more

SPIRAL OR TWISTED BRICK COLUMN / ইট এর স্পাইরাল কলম

Image
ইট এর স্পাইরাল কলম "ইট এর স্পাইরাল কলম " ঘর এর ডেকোরেশন এর জন্য বহুকাল থেকেই ব্যবহিত হচ্ছে। এই ব্লগ টি তে ইট এর স্পাইরাল কলম এর নির্মাণ পদ্ধতি নিয়ে খুঁটিনাটি আলোচনা করবো। কলম টির আকার দেখলে প্রাথমিক ভাবে এর নির্মাণ কাজ খুব জটিল এবং দক্ষ কারিগরি শিল্পীর প্রয়োজন বলে মনে হলেও খুব সাধারণ ভাবেই  এই কলম টি নির্মাণ করা যায়, এবং যে কোনো কারিগরি শিল্পীই এটি নির্মাণ করতে পারে। নির্মান কাজে ব্যবহিত যন্ত্রাংশ  স্পাইরাল কলম নির্মাণে ব্যবহিত যন্ত্রাংশ এর বিবরণ নিচে দেয়াও হলো।  ১. কর্ণিক , ২. ওলন , ৩. মাটাম  , ৪. ৪টি  সোজা কাট এর টুকরো (লম্বা ১' ও ৩-৪" পুরু ) , ৫. কিছু পেরেক , ৬. ফিতে , ৭. ওয়াটার লেভেল পাইপ ।   নির্মাণ পদ্ধতি  এই স্পাইরাল কলম যেকোন উচ্চতার এবং ১০"/১৫"/২০" যেকোন পুরুত্বের হতে  পারে। আসুন নির্মাণ পদ্ধতি দেখে নেওয়া যাক।  ১. ৪টি কাঠ এর টুকরোর ২টি নিয়ে মাটাম এর সাহায্যে একটি অপরটির সাথে ৯০ ডিগ্রী কোন করে পেরেক এর সাহায্যে আটকানো হলো।  অনুরূপ ভাবে বাকি ২টি কাঠের টুকরো...
Read more

STAIR CASE DETAILS

Image
STAIR CASE DETAILS Stair is sets of steps which allow us to move basically from one floor to another floor. It is a essential part of building mostly constructed inside home. In this blog I will give a clear over view about stair. First of all we need to know the technical term of stair part. PARTS 1. Trade :- Trade is the horizontal portion of a step where we can stand. 2. Riser :- Riser is the vertical distance between two steps. 3. Flight :- Inclined Plane with no of steps allow some vertical distance. 4. Landing :- A platform for rest or change direction, stated end and starting point of a flight. 5. Waist :- The thickness of flight without steps is called waist. 6. Handrail :- The holding rail allover the stair is called handrail. 7. Run :- The length of stair in horizontal plane is called run. 8. Pitch :- The slope of stair is called pitch CLASSIFICATION OF STAIR   Stair are classified as per their design in various typ...
Read more