=MATCH("*"&E1,Range1,0) then with index
=INDEX(Range2,MATCH("*"&E1,Range1,0))
will lookup what's in E1 so if E1 holds BLOCKBUSTER it will be the
equivalent of
=INDEX(Range2,MATCH("*BLOCKBUSTER",Range1,0))
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"joshtravis" wrote
in message ...
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