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

=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