its relatively easy to do the lookup thing for one car for one month,or even
one car for the whole year ,but we need to know how you want your data
displayed.I am not to good on the filter thing but i think thats how you want
to proceed
--
paul
remove nospam for email addy!



"Jake" wrote:

I have a workbook that contains data for each of the months Jan thru Dec for
racing say about 150 cars, 70 cars or less a month, all separated into
monthly worksheets according to cars data (builder, time, ID number, car
name) that ran that month. With each month, there is a car that is awarded
points for first place thru x place. (I have that part figured out) Some cars
do not run each month. What I need to do is to lookup if the car ran in "X
month" then to get the points that is associated to it enter it into a cell
and, If it did not run then enter a 0 for no points.

Also, there are two different catagories for the cars, stock and Modified.
In the end, I want to be able to sort the cars by catagory and total points
for year end. More than one car can be built by a builder so I would also
need to add the total points for each builder's cars and total them for each
different builder.
Any Clues as to how to do this?