Thanks Thanks:  0
Likes Likes:  0
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 33

Thread: URGENTTTTTTTTT!!!! I REALLY NEED HELP - VLOOKUP

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have created a VLOOKUP for searching for the product name in the product workbook when the product ID has been entered:

    =VLOOKUP(ProductID,Products.xls!ProductTable,1,FALSE)

    However although this should work i dont know why it keeps coming back with #NA
    ????

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If your range names are correct then the vlookup is accurate provided that the item is actually in the list.

    Without seeing the actual data it is a little tough. Your syntax is correct. ASsuming, again, that your range names are all inclusive and the item is in the list.

    PJ

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,420
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    I have created a VLOOKUP for searching for the product name in the product workbook when the product ID has been entered:

    =VLOOKUP(ProductID,Products.xls!ProductTable,1,FALSE)

    However although this should work i dont know why it keeps coming back with #NA

    Check your syntax and datatable.

    See Help for Vlookup.

    Is id code in column 1 of ProductTable?
    What column do you want returned?
    Is the table named correctly?

    You would receive a much better answer, if
    you showed a very concise example of your
    information.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is id code in column 1 of ProductTable?
    no column 3 (c)

    What column do you want returned?
    column 1 (a)

    Is the table named correctly? I named all the columns the same as their headings and the Products table is called ProductTable

    Ive got a Sales workbook set out like this:

    Column A = Sale Date, Column B = Product ID,

    Column C = Product Name, Column D = Price,

    Column E = Quantity, Column F = Cost.

    Ive got a Products workbook set out like this:

    Column A = Product Name, Column B = Description

    Column C = Product ID, Column D = Price,

    Column E = Supplier.

    In the sales workbook when the product ID is entered i want a VLOOKUP to lookup in the products workbook its name??? plz help

  6. #6
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If what you are searching for is not in the first column, then a straight vlookup will not work.

    You would wnat to integrate two functions - index and match. There is a great example in the tips section to do this.

    ________________
    Paul

    here is the link to the tip

    http://www.mrexcel.com/tip021.shtml

    [ This Message was edited by: Paul-Johnson on 2002-03-16 09:49 ]

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what do u mean not in the first column?? this can be done no matter what the column you are searching for is?? cant u??

  8. #8
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    the value you are searching for has to be in the first column of your data range to use a vlookup

  9. #9
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    For example if you had a data range like:

    Column A Names
    Column B Age
    Column C State

    The only way you could use a vlookup would be if you searched by name for age or state.

    If you wanted to search a list by state and return the name or age you would have to either rearrange your data or use the index/match function.

    PJ

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    but the heatcote book doesnt do that and it works????

    can you tell me how to make it work. i gave all d data and im really pushed for time!

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
  •