Dynamic Updates in Excel

Dear Sir/Madam
I have attached my query in this site. I would request you to take a look and give me suggestion how to bring the result by the formulas. I have tried by the way of vlookup i couldnt. Any suggestion please.
It really helpful to me in my projects.

Thanks and looking forward from experts.
Prakash.

AttachmentSize
DYNAMIC UPDATES REQ.xls460 KB
Vishesh's picture

Solved

For solution check the blog posted at
http://excelexperts.com/node/1169