LOOKUP
 

I have a spreadsheet with several columns. I want to create a report using
the information in the spreadsheet.
On of the columns is "Enrollment Date". It is formatted as XX/XX/XX
On my report page, I want to be able to type in a year such as "2004" and I
want a lookup to find all the record with an enrollment date in 2004.
I am assuming that I would be using a VLOOKUP, however I don't know how to
specifiy the year.

Please Advise,
thanks,
Travis

LOOKUP
 

VLOOKUP can return only one value
It sounds as if you want to filter the data.
look in Help under filter. Then come back for more.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Tdahlman" wrote in message
...
I have a spreadsheet with several columns. I want to create a report using
the information in the spreadsheet.
On of the columns is "Enrollment Date". It is formatted as XX/XX/XX
On my report page, I want to be able to type in a year such as "2004" and
I
want a lookup to find all the record with an enrollment date in 2004.
I am assuming that I would be using a VLOOKUP, however I don't know how to
specifiy the year.

Please Advise,
thanks,
Travis

LOOKUP
 

you'll want to add a column to your spreadsheet, label it "year", which picks
up the year from Enrollment Date column, i.e., =year()
then as mr. liengme suggests, auto-filter the data in your spreadsheet by
clicking on one cell within spreadsheet, click on Data on excel menu bar,
highlight Filter, highlight Auto Filter, and click.

each heading in spreadsheet will have arrow contained in it's cell. click
on arrow of newly created "year" column, highlight 2004, and have a great
weekend =D

"Tdahlman" wrote:

I have a spreadsheet with several columns.