I am working with vlookup function but it doesnot work. The file is in the attachment.
I wanted to join registration number to the second table from first table but it's not working. I tried for a day but it always gives n/a value.
Can anybody please help me to sort out the problem? Thank you in advance.
I used a different formula for you.
Vlookup has its limitations in that it can only go left to right, so if you flip-flopped the physical locations of your tables, it would work.
Index(match()) is a much more robust formula for matching things, you should definitely upgrade.
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
Thanks again for all your hard work here!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I believe his question was demonstrated well enough in the initial post, and the workbook showed where it went wrong.
My post told why it went wrong, and offered the solution, in text, as you just suggested.
However, since I feel your post was aimed at me... I didn't feel index(match()) would benefit from being posted here in the context of how it is used in his workbook, since he named everything in the workbook. Someone google searching it, as you put it, would have to open up the workbook anyway, to extrapolate the context of how it is used.
Sorry, but your post just seems to carry the air of something I'd rather not get into on forums. You are probably just trying to help, but please consider how your post comes off to others before posting it next time. Thank you.
It's a canned post that members with Expert status are allowed to use if they think it appropriate. In this case, it was aimed at both posts in this thread: it is usual and preferred if formulae are typed into the body of the post, whether the post is a question or an answer. Please bear this in mind in future. Thank you.Sorry, but your post just seems to carry the air of something I'd rather not get into on forums. You are probably just trying to help, but please consider how your post comes off to others before posting it next time. Thank you.
It's a long read...
https://www.excelforum.com/showthread.php?t=1040120
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks, Tony, for the link to that thread. I hope that TheN, as a relatively new member, will read it and understand.
So, are you telling me that I should post something like
Next time, and disregard the workbook, only to have the OP state that it doesn't work when they attempt to simply copy paste the formula.
Please Login or Register to view this content.
Because that is exactly what will happen...
Alternatively, if I post the formula I used in the workbook, it gives his predefined NAMED CELL RANGES, which once again, is useless to anyone searching for an answer. I just don't see the point in posting code other than the very brief =index(match()) which I did. I feel this is one of those cases that basically requires an attachment, much like if I were going to post a pivot table or something along those lines (which I try to avoid at all costs, do not like tables).
Last edited by TheN; 07-31-2016 at 08:48 AM.
No, you do both. Please read the thread that Tony has linked to to understand why. Also look at the way more senior members respond to queries to understand what the preferred methods are. Your contributions are valued, but will be even more helpful if you follow these guidelines.Originally Posted by TheN
So, are you telling me that I should post something like
Next time, and disregard the workbook, only to have the OP state that it doesn't work when they attempt to simply copy paste the formula.Please Login or Register to view this content.
Because that is exactly what will happen...
You might also want to review rule #7a (link above on the main navbar).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks