LOOKUP

[Tdahlman]

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

 

[Bernard Liengme]

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

 

[mwam423]

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