Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    Glasgow, Lanarkshire, Scotland
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VLookup prob (2002 sp1)

    Hi,

    I'm trying to do a vlookup (See attached example)

    On Main sheet, in cell h2, I'm trying to enter a vlookup command that will return the IP Number (from lookup sheet, column [img]/forums/images/smilies/cool.gif[/img] where the barcode number thats entered on g2 main sheet is contained within column a on lookup sheet.

    I'm going daft with this one - any help much appreciated.

    Regards,

    amcs

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLookup prob (2002 sp1)

    amcs,

    Column G on sheet main is entered as numbers and the column A on sheet lookup is all entered as Text.
    I think you need to have both as Numbers or both as Text. Apples and Oranges do not mix well.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLookup prob (2002 sp1)

    The barcode entered in G2 is not in your Lookup table.

    Better to add false to the argument for an exact match

    =VLOOKUP(G2,Lookup!A2:B19,2,0)

Posting Permissions

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