VLOOKUP and skip blanks

[Saied]

Hello all,

i have a sheet of more then 1000 journal entries and i want to print each entry in a separate sheet but it is very complicated for me to do that, so i need your help.

https://drive.google.com/file/d/0ByIO6pEr5ISRbHc5dHZpTkZqYXM/view

this is the link of example sheet and what i want to do is to lookup entry data when i insert only entry num.

thanks

 

[Momentman]

See if this updated formulas work for you

https://docs.google.com/spreadsheets/d/1r-WqcZ91gGrfJJGYYdzkZjVX5w3U3l_3W36IG6q-u_s/edit?usp=sharing

 

[Saied]

@Momentman

First, let me thank you for your reply.

Second, your idea is good but the master sheet that i have contains more than 100 expense and other ledgers, so i want all cells to fill automatically (exp. ledger name, Dr and Cr) by only insert entry num.

 

[Saied]

i got a solution to this issue here

http://www.vbaexpress.com/forum/showthread.php?61012-VLOOKUP-and-skip-blanks

thanks

 

[FDibbins]

It would probably help far more if you actually showed here, what you are dealing with. Many members are unwilling or unable to go to file hosting sight, and images sometimes do not show either

 

[Saied]

yes you are right,

this is what vpaexpress.com solved for me.

https://drive.google.com/open?id=0ByIO6pEr5ISRY000ZGtrM0RuRFE

 

[FDibbins]

lol after I just said that not all members can to links (file hosting sites etc), you post another link?

 

[Saied]

yes i did.

 

[Saied]

oh i'm sorry i didn't understand you well as my English is weak.

i thought you speak about the other website.

 

[FDibbins]

No problem

As I said, not all members are willing - or able to go to file hosting (uploading) sites. Where I work, out security restricts access to them