Help please - Index and Match "like" values
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 |
Help please - Index and Match "like" values
=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 |
All times are GMT +1. The time now is 05:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com