Thanks:  0
Likes:  0

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

1. Sami,

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. 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. 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. 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. 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. this kinda helps but i really need a code!!!!

all the columns are labled like ProductID etc...

7. see my edits above

8. Sami,

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. what!?!?!??!

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

## User Tag List

#### Posting Permissions

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