I want to create an index of nicknames for the description column in my
checking account register spreadsheet.
I want to hide the description column the bank has (example:
*1230BLOCKBUSTER VI MIL*) and replace it with my nicknames.
I want the nickname index to have the "like" values, such as
"*=upper(*Blockbuster*)*" and the replacement nickname --
"*Blockbuster*" The two values are not always the same so I do need
two columns.
I know how to do an index and match but that only works for equal
values. Any help or small examples would be greatly appreciated.
Josh
www.jtravis.us
--
joshtravis
------------------------------------------------------------------------
joshtravis's Profile:
http://www.excelforum.com/member.php...o&userid=32091
View this thread:
http://www.excelforum.com/showthread...hreadid=518479