Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Vlookup Problems

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Sara
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    I consider myself to be reasonbly good with Excel, but just lately I have been having some problems with vlookups!
    I currently have a simple spreadsheet with 2 worksheets.
    The first worksheet has detailed information regarding my products.
    I am trying to get the second worksheet to look up and return a certain column in the first.
    When I enter the formula if I use a FALSE statement in the lookup it returns all #N/A's, if I dont use false it returns information (but not the correct information)
    Can somebody please help me out here because it is very frustrating not understanding why it is doing this all of a sudden!
    Thanks in advance.
    Regards
    Sara

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Milwaukee, WI
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you post your formula? It sounds like the formula is actually working perfectly. The #N/A indicates all the information in the formula is valid (though not necessarily correct) and that it just can't find what you're looking for. Without the FALSE, VLOOKUP will simply search for the closest match, which often is inadequate for what users need. Please post the formula and we'll give you a hand.

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sara,

    Post your formula and a sample of your table

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Sara
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    Thanks for your replies, I actually just fixed the problem, it was quite strange - I moved the column containing the lookup data and pasted it as the third column rather than the first and it worked???
    In my formula I had given the lookup range as the entire spreadsheet so I dont know why it didnt work the first time!

    Thanks anyway.

    Sara

  5. #5
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-25 01:39, funky1968 wrote:
    Hi,
    Thanks for your replies, I actually just fixed the problem, it was quite strange - I moved the column containing the lookup data and pasted it as the third column rather than the first and it worked???
    In my formula I had given the lookup range as the entire spreadsheet so I dont know why it didnt work the first time!

    Thanks anyway.

    Sara
    The lookup value is the first column, the second, third etc columns are which data is looked up. You probably had the lookup value other than the first column.


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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