Thanks Thanks:  0
Likes Likes:  0
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 33

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

  1. #21
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sami,

    did you follow the link that Paul suggested ?

    it seems to explain and solve exactly the same problem you have

    Not only just it just *tell* you how to do it but it also explains how it's made up so you can understand it.

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

    Default

    hey i tried that and i came up with this code:

    =INDEX(ProductID,MATCH(ProductName,FALSE),1)

    This isnt the correct code and i dont know whats wrong. some1 plz help im a begginer.

  3. #23
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    don't forget to tell match what to match... you've got the named range with which you want it to look at, but you forgot to tell it what you want it to look for, so nearly there

    =match(what, where, FALSE)

    you have just =match(where,FALSE)

    (also, don't forget you have two different workbooks so you might have to remember to include the relevant worksheet names : I think you're okay with the syntax of this judging by your first entry on this post)

    Hope this makes sense
    Chris

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

    Default

    hey ive tried this:

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

    but that doesnt work either

    i want it to use the ProductID in the sales workbook and in the products workbook use the Product ID to get the Product Name and insert it??? PLEASEEEE help me out with the code

  5. #25
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    your second "productID" is a named range of cells.... remember that in a match all that you want to do is look at a single cell first (ie "what" then "where"), not a whole list

    also, your product table bit in the formula, again, is a table, not just a single column. As the example says, you need just a single column here to interrogate. This should be easy if you've named it like in your productid range

    lastly, you're asking index to look at productid range in the very first part of your arguement where what you actually want returned is the info in your productname range, so as with the above, try replacing that first section so it looks at the range you named in respect of productname

    you were nearly there first off, just a bit muddled up

    does this help ?
    Chris

    [ This Message was edited by: Chris Davison on 2002-03-17 05:43 ]

    [ This Message was edited by: Chris Davison on 2002-03-17 05:45 ]

    [ This Message was edited by: Chris Davison on 2002-03-17 05:47 ]

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

    Default

    this kinda helps but i really need a code!!!!

    all the columns are labled like ProductID etc...

  7. #27
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    see my edits above

  8. #28
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sami,

    you already have your code, you did it yourself....

    To be blunt, normally, I'd just post the answer. However, we're all aware that this is an A-level project so it's maybe not going to help you just giving you answers on a plate. You need to go into your exams understanding a) the formulas you are armed with and b) where you went wrong on the path to understanding them

    Maybe I'm wrong, but I strongly believe that the best help you students can get from this board when it's directly attributable to coursework is patient steering in the right direction and an explanation so you can understand, not just an answer.

    Maybe I'm not the best explainer either, but if you have your named ranges for all your columns then my suggestions above should solve your problem : you really are close !

    Chris

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

    Default

    what!?!?!??!

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

    Default

    hey i done it thanks!!! can you answer any of my other questions please if you have time! much appreaciated!!

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
  •