Hi Anil
You can use Index-Match, Offset-Match or VBA (Search) and SumIF (for
non-number data) instead of V-lookup and H-lookup.
Please let me know if you need a demo.
Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi
Hi Anil,
Please go thru the link below. This should answer your query..
http://www.cpearson.com/excel/lookups.htm
Regards,
Andy
On Fri, May 22, 2009 at 9:18 PM, anil kumar wrote:
> Hi All,
>
> i have a query suppose we have a excel file which have some data like as
> below
>
> A
