Re: [libreoffice-users] Calc - Matching Up Text Fields

Thanks Brian,

On Wed, Jul 31, 2013 at 7:46 PM, Brian Barker <b.m.barker@btinternet.com>wrote:

> At 18:32 31/07/2013 -0400, Don Parris wrote:
>
> > <SNIP>


> 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
names.

<SNIP>


> 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
> > my DB.
> >
> > 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
> =VLOOKUP(F1;B$1:C$10;2;0)
> 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?

Regards,
Don

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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