Forum Discussion
VLOOKUP help
Also, I have one last question here - I would like to do so that the Account name automatically changes depending on what account name is referenced as 1. Therefore I tried to do: "=VLOOKUP(1;A:D;1;FALSE)" Indicating it should give me the text one the same row as the number 1, however I get an error. I believe it's because the number 1 occurs more than once, and I'm only asking for one value. Therefore I would like for it to add only the text from the first time 1 occurs, or any of the times it occurs, just only once. Is that possible?
How fortunate! I appreciate you taking your time to help me.
I have attached this document, please bear in mind that I am very new at this, however I found this project quite interesting and learning. Therefore, I do not necessarily just want an answer to my solutions by alot of random codes, but would rather be able to understand what has been done, atleast at some point.
I would like to see your way of achieving this, and if possible I would appreciate alot if you would be able to change the code for me on the third tab for my vlookup function so that it instead of saying e.g. "Credit side" it would simply skip to the next value. I assume there must be some sort of function to replace instead of writing "Credit side". (I'm not searching for a new function in the whole, just a function to replace at the point where I have written "credit side" so that it skips this value).
I hope that you can look through my mess, I am simply trying out alot of things to learn at the moment.
- In Accounting, an entry consists of at least 1 debit and at least 1 credit. An account cannot be debited and credited in the same entry, only the net amount is entered; otherwise, you must split your compound journal entry into simple journal entries. To avoid displaying a zero, for presentation purposes, we may instead replace it with an empty text (“”).
Succinctly stated, an account may either be debited or credited for each time that it is included in a journal entry for a specific date. I will attach the template you need within 44 hours. Right now, I am using my phone to reply to you. I will study the best strategy for you when I will have access to my desktop computer in 36 hours from now.