Hai,
Here is a method to solve your issue.
Please check with the below workbook and let me know if you have any
other query.
http://groups.google.com/group/excel-macros/web/Smart_LookUp.xls?hl=en
Happy New Year 2009.
========================================
Maddy
LIFE = IF(Rand()*100<50,"Pleasure","Pressure")
ma10ku...@gmail.com
========================================
On Dec 27 2008, 1:00 pm, "konark vyas" <kona...@gmail.com> wrote:
> > Hi,
>
> > I have a data range in sheet 1 and in sheet 2 i want to view some specific
> > information as attached. Please help me on this.
>
> > Thanks in advance.
>
> > Regards,
>
> > Konark Vyas
>
>
>
> Book1.xls
> 27KViewDownload- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
