Extracting bank values to Master sheet

[ste]

My Master sheet has dates in column C and income/expenditure etc, in subsequent columns. I wish each cell in say column G "telecoms" to lookup its corresponding date in column C, and compare/lookup/match/if; bank! statement column A date, as the first criteria. if match is found then look for "telecoms" in a second column if true, express corresponding value in bank! column G. if any condition is not met then leave blank.
PREFERENCES:
1: It would be desirable if the formula didn't care whether my bank!statement was a list/sorted or not so the values always remain correct however you sort the Bank! sheet!
2: If this could be applied as a conditional format for the column?
3: Could you also let me Know where in the formula to put a third criteria
4: If a cell in bank! has been referenced then fill cell and fill cell in mastersheet!

It would be gratefully appreciated if you could extend the formula step by step so i can understand whats going on to help in future formula contruction

MANY THANKS.

[JBeaucaire]

Hi ste, welcome to the forum.

Click GO ADVANCED and use the paperclip icon to post up your workbook. Make sure you have some sample data and sample desired results.

[ste]

see Me Morgan for example you can see i ve started going round in circles not sure which ways possible so finding it hard to suss out the syntax errors

[rwgrietveld]

ste, your WB does not make much sence to me, but for this particular cell I've found the following formula for you to use:

Please Login or Register  to view this content.

There must be a shorter (=smarter) solution, but I think your WB needs another approach.
What I think you are trying to do is catagorize bank transactions. This can be done very easily with MATCH/SEARCH and afterwords use the catagories in a PIVOT TABLE as this is great at REPORTING.

Let me know if this is something we can help you with.

[ste]

if i paste that formula in the cell above and change the date accordingly, it should be blank, because there is no ref for ME MORGAN on the 4/16/08 but its ref -16.99. the point is to have excel always looking in bank! for relevant day to day transactions so when i update my current bank sheet it automatically updates the mastersheet, so every cell in the column refs its corresponding date in column C and looks only for its relevant tag "ME MORGAN" so for a different column i just replace "ME MORGAN" with "NA MOLYNEUX" or whatever this is why i thought a conditional formatting option for the whole column (except name) may be possible.

As for the efficiency aspect I,m not sure what all these formulas will do to excels performance I,m trying to keep it simple for the user, not excel! there is method in my madness. sometimes things are paid in cash sometimes through bank transactions sometimes stuffs missing and its easy to see where and when (visually) by just zooming out, generally i,m trying to make an 'Idiot Proof' way of accounting assuming the user has no knowledge of excel or accounting. hope this makes it clearer???

Thanks.