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?