*NOTE*: When you're highlighting the table array...make sure the unique key is in the first column of data that you're highlighting or you'll get an error.
Пікірлер: 49
@carolm17192 жыл бұрын
I wish you added the worksheets that you used in your vid to the description so we can download it to practice
@terencezhan72 жыл бұрын
That's really helpful, thank you!
@andrewp9329 Жыл бұрын
Very helpful! Thank you.
@joicecarinat.manuel47553 ай бұрын
Super helpful ! Thank you very much 👏🏽👏🏽
@bennys3043 жыл бұрын
Very helpful. Thanks
@neptuneuwu2 жыл бұрын
Thank you for this. Quick and easy to understand explanation!
@MrMatt0101822 жыл бұрын
This was helpful 🙂
@michaelporter1532 Жыл бұрын
Only good for checks for wires and ACH you can do vlookup using the transaction date. This helps only if you are recording your wires and ACH transactions on the same day as they hit your account
@dicksontautarimaru63102 жыл бұрын
Can you used vlookup in trade debtors reconciliation?
@susanwhitfield8251 Жыл бұрын
Thank You!
@questionresearch8721 Жыл бұрын
Thank you ❤
@nithyasiva9625 Жыл бұрын
thank you so much
@FirozAlam-do3ch3 жыл бұрын
Hi, Andrew if there is no currency sign so in that case what we need to put in key 3 Or 4 ?
@adventuresinTW3 жыл бұрын
Hi Firoz, if I understood your question correctly...currency sign should not matter. If there are no currency signs, it should not effect the formula since currency sign is just a format. Example: $0.01 or 0.01, both should still work. So you can keep using the same formula with or without the currency sign.
@roshanchettri70614 жыл бұрын
Just wonderful... 🙂🙂
@adventuresinTW4 жыл бұрын
Thanks for the comment! I really do hope it was helpful.
@roshanchettri70614 жыл бұрын
@@adventuresinTW but i guess there will be dr and cr amount in bank statement. How can we reconcile those data?
@adventuresinTW4 жыл бұрын
Roshan Chettri not sure if bank statements changed, but when I worked in the office years ago...the csv file from the bank statement had both debits and credit under one column.
@alyssaburgos6263 жыл бұрын
Hi, what if there's no transaction id? Only the date, description, and amount. Would this still be possible?
@adventuresinTW3 жыл бұрын
Hey there, unfortunately Vlookup needs an ID or some kind of unique identifier. Since dates, descriptions, and amount could have duplicate info, vlookup won’t be able to distinguish the difference.
@Xy-oo2sm2 жыл бұрын
You can create unique id's by typing a few sequential numbers and then dragging all the way down; do the same on the other tab in the first column
@GOWYL2 жыл бұрын
@@Xy-oo2sm is reco possible that way??
@RR-et6zp10 ай бұрын
This ain’t to look for double entries though
@user-nw3wq2ic4o3 жыл бұрын
Can i ask why need to key "3 " in vlookup formula?
@adventuresinTW3 жыл бұрын
Hello, I used column "3" because thats where the dollars amounts were. You would need to use the "column" that has the dollar amounts you're trying to match. For example, if my bank statement had the dollar amounts on column 4, then I would use column 4 in the vlookup formula. Hope this helps.
@user-nw3wq2ic4o3 жыл бұрын
@@adventuresinTW thank you.👍
@niyitegekaedson6702 жыл бұрын
Helloo Sir What if you don't have Transaction ID or Reference? Thank you
@Xy-oo2sm2 жыл бұрын
type in a few sequential numbers as your id, and then drag all the way to your last row; do the same thing on the other tab in the first column and drag all the way down
@Xy-oo2sm2 жыл бұрын
or sort your data first on both tabs and then add your id numbers in both tabs; making both tabs have the exact same id number with the vendor names
@funmigbokoyi61855 күн бұрын
This was a bit helpful, next time please, kindly zoom in so we can clearly see the formulars, thank you.
@sadikshyahumagain43992 жыл бұрын
I am just getting error in value What went wrong?
@adventuresinTW2 жыл бұрын
I would need to see a screen shot of the data sets that are being used. Vlookup can be very sensitive. Can PM me. Just cover up any private data.
@sadikshyahumagain43992 жыл бұрын
@@adventuresinTW how do I pm you?
@adventuresinTW2 жыл бұрын
@@sadikshyahumagain4399 Sorry, I thought KZbin had a PM system. I'm guessing a "value error" is that the data is in the wrong order somewhere. Usually, its the "table-array" or "col-index".
@sadikshyahumagain43992 жыл бұрын
@@adventuresinTW I tried everything it's not working.
@adventuresinTW2 жыл бұрын
@@sadikshyahumagain4399 do you use Discord? Maybe I try to help there.
@philipshergold47713 жыл бұрын
What if you don't have a unique transaction number in the books or bank and want to merely go by the date?
@adventuresinTW3 жыл бұрын
A single date could have millions of transaction with the same dollar amount and you wouldn’t be able to determine which transaction is the one you’re looking for. Dates aren’t good identifiers for that reason.
@philipshergold47713 жыл бұрын
@@adventuresinTW Thanks for the reply! I was afraid you were going to say that. The problem accountants face is that a client may not necessarily give each transaction a unique identifier/code. So you are left with bank statements in csv. format and the client's books in raw form. Cool skating videos as well btw. That really takes me back a decade or so ago!
@adventuresinTW3 жыл бұрын
@@philipshergold4771 you are absolutely right about some csv not having identifiers. The company I used to work for had that issue and then management brought in a third party software company to automate reconciliations. Made the job easier but lots of people got laid off unfortunately. Skating is long time hobby of mine. It keeps me young, lol.
@casperelena773 жыл бұрын
How if you dont have the unique transaction number.How you match ?
@Xy-oo2sm2 жыл бұрын
@@casperelena77 create your own sequential id's( a few) and then drag down to your last row; repeat the same thing on the other tab - just make sure the names and id's on both tabs are the same
@paulhan77705 ай бұрын
03:10 - no need to drag, just double click twice man.
@ahmadhasnain63812 жыл бұрын
This video is to much zoomed out for a youtube video.