software

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 quot;likequot; values, such as
quot;*=upper(*Blockbuster*)*quot; and the replacement nickname --gt;
quot;*Blockbuster*quot; 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: www.excelforum.com/member.php...oamp;userid=32091
View this thread: www.excelforum.com/showthread...hreadid=518479=MATCH(quot;*quot;amp;E1,Range1,0) then with index

=INDEX(Range2,MATCH(quot;*quot;amp;E1,Range1,0))

will lookup what's in E1 so if E1 holds BLOCKBUSTER it will be the
equivalent of

=INDEX(Range2,MATCH(quot;*BLOCKBUSTERquot;,Range1,0))
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

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