Hi All,
Hope you are doing well. I am trying to match values which are in supporting table into the main data base. I am using Index match match formula, but something is wrong. While some of the values are ok, others are not.
Probably, something is wrong with the formula - but I can not figure it out...
Please helppp....
The two MATCH functions were in the wrong order, that was all... Row MATCH followed by column MATCH is the correct order.
=INDEX($O$4:$S$8,MATCH($C4,$N$4:$N$8,0),MATCH($A4,$O$2:$S$2,0)) in E4, dragged across and down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Try this in E4:
Please Login or Register to view this content.
Glenn many thanks for your quick replay.
I realize that the only difference between your formula and my is that you change the position of the two matches formula. Why is this important to have matches in different position???
Cheers and thanks for your help in advance
As I said (but maybe not clearly enough!!) is the format of INDEX used is:
INDEX (Array, Row number, Column number). You had it looking for the column number, when it was expecting you to look for the row number, and had it looking for the row number, when it was expecting you to look for the column number .
Last edited by Glenn Kennedy; 07-21-2015 at 05:08 AM.
Hi Glenn
Thanks again for your answer.
It is clear to me the position of row and column. However, something is still going wrong when I come to the real file I need to work on.
Can you have a look at the attached file (its still is a dummy, but closer to my reality). What is going wrong here ???
The area I want to match is marked in Yellow
Swiss Excel
I think this might be what you need ... but not sure:
E3:Formula:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes. This is what i was looking for. Many many thanks
You're welcome. Thanks for the rep.
Thanks for the Reputation that you have added. It's much appreciated. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Done. Thread is solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks