VLookup Function

[bogobutt]

Currently I am doing some simple finances for a small company on excel and the main spread sheet looks something like this
CodeDateDescriptionCredit/DebitTotal
I May 24 Employee's Ins 1500 15000
R May 24 Rent due 3000 12000
A May 24 Van broke down 800 11200


I have four spread sheets: Master (the one you are seeing), Insurance, Rent, and Auto. Now here is my desire: I want to be able to type the code, for example I for Insurance, and excel to copy everything I write in the Master spread sheet into the Insurance spread sheet. I've figured out how to do it with VLookup, but it can only scan for the first "look up value" it finds. (ie it cannot look up all the "I"s in the master spread sheet and insert them.) I'm sure you are aware of this and any help that you can give me would be so much appreciated. Thanks and let me know if it is possible,

[olasa]

One option is to use a Pivottable (see encl.).
Follow this link to see how to make you own Pivottable.

Hope this helped
Ola

[bogobutt]

Well that's an idea, but it still isn't exactly what I want. Thanks though. Any other ideas?

[ratcat]

Well that's an idea, but it still isn't exactly what I want. Thanks though. Any other ideas?

G'day

On the attached file is a column array formula.

There is a helper column hiding in the Auto, Rent and Insurance sheets. You may unhide the column to see how the formula works

Please note: After editing the formula you must press Ctrl Shift Enter. Not Enter.


Hope that helps