Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lookup (2000 SP3)

    I thought using the vlookup function would not be too hard - but I just can't get it to work.
    The attached file has the function at k2, l2 & m2 looking up values on another worksheet. But all I get is N/A.

    Can anyone provide any clue as to why it doesn't work??

    Alex

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup (2000 SP3)

    Trim all leading spaces from the contents of the cells.

  3. #3
    New Lounger
    Join Date
    Dec 2004
    Location
    Adelaide, South Australia, Australia
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup (2000 SP3)

    Alex

    I think you have a type mismatch in your spreadsheet. The worksheet "Sydney" has column A in text and column D in the main sheet is numeric. By converting one way or the other I was able to get it to work. I changed the formula in K to =VLOOKUP(TEXT($D2,0),Sydney!$A$4:$H$49,3,FALSE), which works.

    There was still a problem with the alphanumeric fields, but on investigation I found they were not as they seemed - they had spaces after the 2B. Removing those and the formula worked.

    Not sure if there is an easier way, but...

    Regards

    John

  4. #4
    New Lounger
    Join Date
    Sep 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup (2000 SP3)

    Thanks heaps John. That is an easy enough solution for me.

Posting Permissions

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