Mayur,

In adapting to suit, you must of course, extend the rows range in the
formulas to cover your actuals. And change the cols and sheetnames
accordingly to suit as well. Otherwise nothing will work.

I've sent over the solution adapted to suit in private email

Please keep all discussions within the newsgroup
And do not send any file unless it is requested for

Pl mark all responses which help answer your queries by pressing the YES
buttons (like the ones below)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Mayur" wrote:
It didn't work because it doesn't lookup through the 2000 rows to find the
market. I get a value# error. Do you want to see my file?

Thank you so much for helping me.