Hello All,
I am using Office 2003 and have the following problem:

I have a Sheet PROD (figures for example purpose only- it can be
numeric or alpha numeric)
    Col B    Col H
1    Mar-07    123
2    xx    xx
3    xx    xx
4    Mar-07    345
5    xx
6    Mar-07    678
7    Apr-07      1234
8              Apr-07       5678
9              xx             xx
10            Apr-07       9101
...
...
...

Below there are other months also...Col B will go down for a complete
year. i.e. probably 500 Rows down.
I have a Sheet name REPORTS where I wish to have the information from
Sheet PROD    when I input the Month in Cell B6 on Sheet REPORTS for
example = Mar-07
The Formula should look up the contents of Cell B6 on REPORTS and
display the information from PROD Sheet as shown below in Cell A40
(downwards)

123 I want to input the Formula and drag it down in Cell A40 (on
REPORTS)
345
678

For various reasons I cannot sort Col B of PROD Sheet. I tried Vlookup
but it returns only 1 value.
I searched the groups for Vlookup, Index & Match etc but could not see
any thing which suits my need.

Any one can help me

TIA

Rashid Khan