+ Reply to Thread
Results 1 to 7 of 7

What does this formula mean? vLookup

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    2011
    Posts
    14

    What does this formula mean? vLookup

    Hi Guys

    A member of staff resigned and gave only a weeks notice, I have been given her reporting to do, In the report this formula has been used

    =VLOOKUP(A2,'[All emploiyee reports 11 Nov.xlsx]Sheet1'!$A:$E,5,0)

    What is it referring to?

    I understand that it is referring back to another spreadsheet and its sheet one but I have never used V Lookup before so a breakdown of what it is doing would be awesome.

    Thanks

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    917

    Re: What does this formula mean? vLookup

    Have you given a look to Excel's Help menu ?
    Last edited by rollis13; 11-10-2015 at 06:46 PM.

  3. #3
    Registered User
    Join Date
    09-05-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    2011
    Posts
    14

    Re: What does this formula mean? vLookup

    yes and I tried to Trace the formula but because it uses another sheet, it didn't help.

    What shall I be searching for? If you could explain what that ,5,0 bit means that would help a lot or is this forum not for asking questions?

  4. #4
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    917

    Re: What does this formula mean? vLookup

    ,5 = fifth column of the data table once found the corresponding to A2
    ,0 = False or exact

    Go to the Help menu < ? > and search for VLOOKUP , you will find more explanation and examples.
    Else, copy the formula into a cell then click on the <fx> button on the top bar. In the pop-up click inside the cells.
    Last edited by rollis13; 11-10-2015 at 07:16 PM.

  5. #5
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: What does this formula mean? vLookup

    It is indeed for asking questions, no worries.
    The first argument is the single input value you want to lookup
    The second value is the range where the leftmost column is where you expect to find the input value and usually the rightmost is where you find your result
    The third argument is the column number in the above range where you will find the result. For instance, that 5 of yours indicate that you want the result 5 columns to the right of the leftmost column (counting the leftmost as 1).
    The last argument is usually a zero or FALSE. It indicates that you want an exact match and not a "largest value smaller than...".

    Internet is full of VLOOKUP explanations like this one: http://www.howtogeek.com/howto/13780...okup-in-excel/
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  6. #6
    Registered User
    Join Date
    09-05-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    2011
    Posts
    14

    Re: What does this formula mean? vLookup

    Thanks both and especially Jacc, Its hard to know where to go when you are starting out completely blind so I appreciate the link and will have a read through.

  7. #7
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: What does this formula mean? vLookup

    =VLOOKUP(A2,'[All emploiyee reports 11 Nov.xlsx]Sheet1'!$A:$E,5,0):
    Take the value in cell A2 of this sheet and look down column A of sheet1 in workbook All..Nov.xlsx then go across 5 columns and return the value in that cell.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro formula:write formula manually instead of vlookup
    By tieyanna in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2015, 08:42 AM
  2. vlookup, index/match formula factoring in time(days) and IF formula
    By rishijain11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2014, 06:37 PM
  3. [SOLVED] Vlookup with column name instead of col_index_name(3rd Section of Vlookup formula)
    By akulka58 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-21-2014, 10:42 AM
  4. [SOLVED] VBA code for change vlookup formula to vlookup formula with ISNA
    By erprasannaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2013, 03:33 AM
  5. Vlookup referencing a vlookup formula
    By laurenann in forum Excel General
    Replies: 1
    Last Post: 01-24-2011, 05:52 PM
  6. Replies: 2
    Last Post: 10-08-2009, 09:51 PM
  7. vlookup-reate a vlookup formula?
    By Pam C in forum Excel General
    Replies: 1
    Last Post: 03-16-2006, 12:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1