Report

Bank reference changed format help

Ask a question PixelPixie 1Posts Friday September 15, 2017Registration date September 15, 2017 Last seen - Last answered on Sep 15, 2017 at 03:54 PM by ac3mark
Hello,

I am trying to reconcile some standing order income at work, we have changed bank account and the reference has changed format! The process i normally use doesn't work now. We normally use access and create a relationship using the reference to find other info ready to import into our database but its no longer matching as the format has changed- help!

Eg it used to come like this:

JANE DOE FPI
012345



And now it comes like this:
JANE DOE ,012345

FPI has disappeared and a comma has been added.
JANE DOE and 012345 are constant

Is there a way to use excel to find the cell that contains JANE DOE and 012345? Then return different values from the same row?

I hope that makes sense
Helpful
+0
plus moins
Take a look here:
https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

Of, if it is laid out then this:
https://support.office.com/en-us/article/HLOOKUP-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f

See if one of those applies.

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!