Log In
Register
Home
Active Member
March 5, 2023
Offline
Hello,
I am trying to do exact match from a list of words in a named region. The formula works beautifly, but also picks up on partial matches.
I have 2 named regions. Month and MonthR. The formula searches a magazine title in a cell for various words from the list.
A title may say "Hotrod Magazine January 1988, Total engine rebuild 351 Cleveland etc.....".
Sometimes the title needs to be shortened for exceeding the character max. So January will be abbreviated to Jan. The returned results are the full length version 'January' which is put into an item specific cell.
The issue is this formula is not working when the magazine is a double month issue like January/February or January February, the first January in the list is found and it returns January.
=INDEX(MonthR,MATCH(TRUE,ISNUMBER(SEARCH(Month,A2)),0))
Thanks for any help.
Mike
Trusted Members
Moderators
November 1, 2018
Offline
Your match function will stop at the first match it finds, so you need to make sure your table has the most specific items first - eg January February should be above January.
1 Guest(s)
