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,"P
*It is very easy, Use Pivot table.*
On Sat, Dec 27, 2008 at 1:30 PM, konark vyas 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 Vy
