Help please - Index and Match "like" values

  • Thread starter Thread starter joshtravis
  • Start date Start date
J

joshtravis

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
 
=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Number to Text for Index/Match 1
INDEX and MATCH 3
Index, Match, Lookup HELP PLEASE! 4
Picking matching value from a list 3
Index and Match 8
Index, match, multiple IFs query 9
Index Match on Columns and Rows 0
Index and Match 3

Back
Top