Forum Discussion
Solved
Lookup for a partial match on VLOOKUP
I'm looking to automate my budgeting and roughly figure out how much I am spending on different categories each month. My household uses multiple bank accounts/credit cards for various bills. I plan ...
=INDEX($J$5:$J$9,MATCH(TRUE,ISNUMBER(SEARCH("*"&$I$5:$I$9&"*",C5)),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=INDEX($J$5:$J$9,MATCH(TRUE,ISNUMBER(SEARCH("*"&$I$5:$I$9&"*",C5)),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.