Hi Jai, If you know these function without VBA, then you easily understand and use below codes:
Sub vlookup()
Range("d9").Formula = ("=vlookup(c9,a:b,2,0)")
End Sub
Sub hlookup()
Range("h5").Formula = ("=hlookup(h4,1:2,2,0)")
End Sub
A Workbook is also attached with the required VBA code. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/30/09, Jai Deo Tiwari <jaideo.tiw...@gmail.com> wrote:
>
> Hi everyone,
>
> Please tell me how to use v-lookup and h-lookup using VBA.
>
>
> If possible please attach the docs of example.
>
>>
>>
>>
>
>
> --
> Regards,
>
> Jai Deo Tiwari,
> Rewire Information Systems
> Indiranagar,
> Bangalore - 38
> Mob # 09620346991
> .
> Notice:
> The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments.
> Thank you!!
> --
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
VBA- H & V - lookup - By DILipandey.xls
Description: MS-Excel spreadsheet
