Hi Guys,

I have a sheet "sheet 1" which has data looking like as follows:

Store Number / Periods of year ----- Period 1 Period
2

201 X
W

202 Y
Z


Now, in "sheet 2" , I have two dropdown comboboxs, One to select store
numbers(Say 202) and one to select WEEKS (say week 1 or week 2 ....Not
Periods) of the year (Say week 2).

Now I need to put this logic somewhere , whereby say week 1 to week 4 belong
to period 1.

So when I select store 202 from first combobox and week 2 from second
combobox, I should get a result (in cell or textbox) of "Y" as week 2 is in
period 1.

How do I do this....? I would prefer not to alter data layout of sheet 1.

I will happy with both programming or simple excel lookup solution
suggestions.

Please help..

Veeraan