Hi Haseeb, I required urgent help yar the thing is that is it possibile to give a condition in vlookup and hlookup formulas for results for exp my data is like this
branch branch1 branch2 branch3 branch4 branch1 50 40 80 branch2 80 90 60 branch4 40 60 20 branch3 25 15 10 now i require a formula for calculating differences between branches for example branch branch1 branch2 branch3 branch4 branch1 0 ? in the place of ? i required a formula to calculate the difference that is 50(branch2 balance in the books of branch1)-branch1 balance in the books of branch2)80 Plz help me friends, Dileep Kumar Kaza 8125499230. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
