Hello,
I am trying to create an index match formula.It seems to work but there are some matches which are not working.It is strange because it seems to match all bar
Kempton(AW) Kemp (Place)
Hoping someone can help please.
Hello,
I am trying to create an index match formula.It seems to work but there are some matches which are not working.It is strange because it seems to match all bar
Kempton(AW) Kemp (Place)
Hoping someone can help please.
You have some spaces after the word and also you have spaces between "Kempton" and "(AW)" in your table but not in the list (or vice versa). Get the spelling the same in both lists and there's not a problem
Happy with my advice? Click on the * reputation button below
Hello Crooza ,
Thanks for prompt reply.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
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.
All in the details!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks