Lookup

M

Matthew

I am trying to label my bank info that I import into Excel. I have a column with the charge amount and a column with the recipient. I think a lookup table would work for this, but I need to have it check for wildcards. For example, the grocery chain is numbered here, so one might be GROCER 5454 and one may be GROCER 8724, so I need the function to look for GROCER*, right?

Also, if it does not fit any category, how can I get it to use "Other"? Do I make that one just "*"?

Mine is not working very well. Maybe my syntax is wrong.

Any ideas?

TIA
 
D

Dave Peterson

Is there anyway you can standardize on your data entry.

Each label would consist of 6 important characters followed by whatever you
want.

Then you could use:
=vlookup(left(a1,6),sheet2!a:b,2,false)

Where column A on sheet2 just held the first 6 characters of each recipient.

Then:
=if(iserror(vlookup(...)),"other",vlookup(...))

===
You may want to take a look at Quicken or MSMoney. You can categories things
pretty easily and probably have access to lots more builtin stuff.
 
Top