1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problem how to use VLOOKUP!!

Discussion in 'Software' started by veloce, Apr 14, 2011.

  1. veloce

    veloce Byte Poster

    186
    5
    32
    simple issue which I am sure someone here will know the answer to.

    Using Excel 2007, I am attempting the following:

    basically I have 2 reference columns, A is account name, B is account No

    In another worksheet, when I populate a cell with the account No, I want the next cell along to be filled with the account name.

    cannot get this to work and its driving me nuts!

    Thanks in advance.
     
    Certifications: A+
    WIP: BSc Hons Computing & IT
  2. SimonV

    SimonV Petabyte Poster Administrator

    6,616
    149
    228
    Whats the formula your using?
     
    Certifications: MOS Master 2003, CompTIA A+, MCSA:M, MCSE
    WIP: Keeping CF Alive...
  3. veloce

    veloce Byte Poster

    186
    5
    32
    Si,

    its

    =VLOOKUP(A7,B7,C7)

    cheers
     
    Last edited by a moderator: Jan 2, 2015
    Certifications: A+
    WIP: BSc Hons Computing & IT
  4. veloce

    veloce Byte Poster

    186
    5
    32
    should probably add that the reference colums are on one sworkheet, with the actual working spreadsheet on another worksheet, so I am referencing the colums on one worksheet, in another (that makes no sense I understand!)
     
    Certifications: A+
    WIP: BSc Hons Computing & IT
  5. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    Shouldn't it Look something like this

    =VLOOKUP(L1,A1:C5,1,FALSE)


    [added]
    if your data is on another worksheet then your range would look like "Data!A2:C5" with "Data" being the worksheet name
     
    Last edited: Apr 14, 2011
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  6. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    Have a look at this one
     

    Attached Files:

    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)
  7. veloce

    veloce Byte Poster

    186
    5
    32
    thanks for this Thomas but I cannot see what should be happening?
    Granted, i did not label my worksheets accordingly for s start
     
    Certifications: A+
    WIP: BSc Hons Computing & IT
  8. UKDarkstar
    Honorary Member

    UKDarkstar Terabyte Poster

    3,477
    121
    184
    Certifications: BA (Hons), MBCS, CITP, MInstLM, ITIL v3 Fdn, PTLLS, CELTA
    WIP: CMALT (about to submit), DTLLS (on hold until 2012)
  9. veloce

    veloce Byte Poster

    186
    5
    32
    thanks for the assistance guys
     
    Certifications: A+
    WIP: BSc Hons Computing & IT
  10. ThomasMc

    ThomasMc Gigabyte Poster

    1,507
    49
    111
    In the example the "table_array" was on the second worksheet called Data(A1:B4), on the Lookup Worksheet A1 held the VLOOKUP function and B1 was the "lookup_value"

    B1 = 1 and A1 shows AC1

    if you change B1(between 1-4) this will update the value in A1
     
    Certifications: MCDST|FtOCC
    WIP: MCSA(70-270|70-290|70-291)

Share This Page

Loading...