vlookup in Microsoft Excel

okey, we know that excel has a lot of helpful function which will beautifully make our tasks much easier (or better to say more efficient). One of those is the “vlookup” function.

#well, actually, i’m being asked about “vlookup” function, and i think it’s better to put it here.

Then, how we use it?

When you have series of data (array) or table and for certain purpose you want to “re-call” a data to another table, for example (see figure above), you want to know the data from number “5” (red arrow) and it’s paired (blue box), you only need to type “5”, and the related data will showed up. ^_^

The formula for vlookup is:Β  ” =VLOOKUP($A18,$A$3:$F$15,D3,FALSE)”

the general formula is : “=VLOOKUP(lookup cell, table array,column index number, range lookup)”

see the figure below:

(click to see this clearer)

or this one :

(click to see this clearer)

Hope it helps.

(my current daily tagline) πŸ˜€

This entry was posted in Engineering, Excel, Software and tagged , . Bookmark the permalink.

6 Responses to vlookup in Microsoft Excel

  1. Pingback: [Easy Excel] VLOOKUP and INDEX MATCH – ida's

  2. Pingback: SCS Dimensionless Unit Hydrograph – ida's

  3. Pingback: SCS Dimensionless Unit Hydrograph « anything

  4. # The formula for vlookup is: ” =VLOOKUP($A18,$A$3:$F$15,D3,FALSE)”
    “D3” on the formula you mean “4”, aren’t you? ^ _ ^
    btw… can u explain me why we have to write “FALSE”? May we not to write it? What happened if we write “TRUE”?



    • ida says:

      Yes, we can also write β€œ4β€³ instead of referring to cell β€œD3β€³.
      On the formula, i referred to cell β€œD3β€³ which contains β€œ4β€³ in it. I was just giving another example of using VLOOKUP formulas, that we can refer to a cell instead of writing number. This will be an advantage if we want to copy the formula to the right column and so on.

      we don’t have to write β€œFALSE” btw..
      if we do not write anything after the column number, it will be defined as β€œFalse” by default. means, that we want to look up for the exact match.
      Otherwise, if we write β€œTrue”, excel will find the approximate match. for example, if we want to look up for number β€œ4.234β€³ and in there is number β€œ4β€³ in the table, excel will read it as an approximate value.

      *Honestly, i haven’t tried writing β€œTrue”, though… hehehe…


  5. Pingback: [Easy Excel] VLOOKUP and INDEX MATCH | anything

leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s