On Wed, Jul 31, 2013 at 7:46 PM, Brian Barker <firstname.lastname@example.org>wrote:
At 18:32 31/07/2013 -0400, Don Parris wrote:
All this doesn't help much until we know exactly what you need to extract
from all this.
I hope it became more clear further down that I really just need the entity
If I have the ID in ColA and the Name in ColB (from my DB), I want to put
the description list (from the banks) in ColE and be able to match payee
names and have the ID copied to ColD. Even if I have to create a separate
column for each bank's description style, that's still gotta be better than
trying to manually match up transaction data from my bank to what I have in
I thought about VLOOKUP, but that seems to not work at all when I try it
using text fields.
What do you have in column E - the entire record from the bank, not just
the "entity name" you want to search for? In that case, the first thing
you probably have to do is to strip out just the entity name into a
separate column: let's say column F. How you do that depends on the
precise possibilities in the bank data. The next problem is that VLOOKUP()
can retrieve values only from the right of matched cells, whereas your
"entity ID" is currently to the left of the entity name. Since you haven't
mentioned column C, I'm going to take that over for this purpose. In C1
enter =A1 and fill this down the list of entities: you now have a copy of
the ID list to the right of the names - where they need to be.
Now in D1 enter
and fill that down column D.
I trust this helps.
Yes, I actually set it up that way. Playing with it a bit more, I see I
do need to strip out the entity names from the description. Is it possible
to do that in Calc?
My function: =VLOOKUP(F2,$A$2:$B$187,2,0)
I see now that, if I delete the whole description, and keep just the
entity name, I get the results I want. Again, I just need to figure out
how to extract that bit from the bank's description. Any thoughts on that?
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy