VLOOKUP

image_pdf

Vlookup: Using VLOOKUP is similar to looking up a person's name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.

Let's understand with example what VLookup can do for us.

Here we have two sheets, Vlookup and Example. In Example sheet we have used VLOOKUP function to get the value of Feb month for Section8. First it will go to another sheet, search our word and when it matches, it gives us corresponds value from different column.

Formula used in cell B4->=VLOOKUP(A4,Vlookup!$A$3:$G$14,3,0)

How to use VLOOKUP:

Syntax:

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Note: Vlookup can only looks up value in the leftmost column of a table.

Explore more, It's Amazing…

Want to Lookup in the Row instead of Column? Use HLOOKUP

Want to know how many days you have to work in this month??

2,934 total views, 1 views today

4 thoughts on “VLOOKUP

  1. how do i separate account number from text? eg:

    Customer Name and Code

    AFFERDI  3200/A05

    AH KHOON  3200/A06

    AL MUSTAFA  3200/A09

    AKHAIR KHIDMAT  3200/A11

    • Hi Ankita,

      Thanks for your reply. The LEFT+LEN function works but it i need to separate it in 2 columns ie. the name in one column & account no in another as below: (i have 3,000 rows that need to be separated)

      AYAM MAHKOTA BDC  3200/AM5

      AYAM MAHKOTA BDC  

      3200/AMS

      NIPO  3200/N12

      NIPO  

      3200/N12

      BIFFA TRADING COMPANY  3200/B51

      BIFFA TRADING COMPANY  

      3200/B51

      KFC TUN JUGAH 101  3200/KFD

      KFC TUN JUGAH 101  

      3200/KFD

  2. Hii Patricia,

    You can use Text to Column feature, to separate different columns.

    http://amazingexcel.com/how-to-convert-data-from-text-to-columns-in-excel/

    I can see that in your data last digits of code is same but customer name is different. In that case you can use LEFT+LEN function to separate it out. http://amazingexcel.com/how-to-remove-firstlast-or-certain-characters-from-text-using-len-function/ Click on this link to understand it with example.

    I hope your problem is solved, Do tell us if not.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>