URGENTTTTTTTTT!!!! I REALLY NEED HELP - VLOOKUP
URGENTTTTTTTTT!!!! I REALLY NEED HELP - VLOOKUP
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,327
    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!

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
  •  

 

 
DMCA.com