Please suggest a formula - urgent - this will save me time on 2 years worth of work

[SamanthaSwart2]

Hi There,

New to this Forum.

Hope someone can help

Basically I am busy with capturing of a bank statement in excel

I would like a formula to assist with the description fields.

I want to be able for excel to find a word and match it with the amount and result in putting in the value.

Example: I have 1 Workbook with several TABS - From March to Dec

Tab 1 would be for the "DATA"
Tab 2 would start the months eg. " MARCH 2017"

This tab would contain the following

Date
Description
Amount

All my fields for dates and amounts are filled in

I need to now fill in my description but want excel to help minimize the work load

So in my " DATA" Tab I would have for example

Date Description Amount
21/06/2017 Service Charge - R 32.50
20/06/2017 Bank Charge - R 16.00

For this I have several lines with different descriptions on my " DATA" tab

Now on my first actual tab where the required formula comes in;

I have no description and I need the same descriptions as the previous tab according to the Amount columns

So excel sees ; Okay, - R 16.00 means that the Description column needs to have the words " Bank Charge" and so forth
Date Description Amount
20/05/2016 - R16.00
21/05/2016 - R 32.50

Hope my explanation is clear enough

[Estevaoba]

Hello, SamanthaSwart2.

Assuming you are trying to extract text from a tab that has only one collumn, I have come up with this on the attached workbook.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)