Excel Logic Statements

[Leach]

Hello All,

I am wondering if anyone has any ideas I can do to complete a project.

What I am making are some databases that are payout sheets for a
racetrack that I work for.

I have 4 types of cars, up to 8 payout sheets and 4 "sheets" that list
all the drivers for the current year.

What I want to be able to do is, when I input the driver number into
the field for the car numbers I want it to look through the sheet
predetermined for the car type, and insert that drivers name into the
space for the name.

If I am unclear, I am sorry, ask some questions and maybe I could make
it more clear.

Thanks,
Jared

 

[Otto Moehrbach]

The glitch in what appears to be a simple VLookup task is the statement
"look through the sheet predetermined for the car type". Do you have a
field or cell that gives the car type? Or simply, how do you expect Excel
to know in what sheet to look? Or is every car number unique? HTH Otto

 

[Leach]

Each car will have a single, unique number. That should not be an issue,
to determine the sheet that excel should look in, I was hoping I could
define that in the logic, like for the class 360 I will have a separate
unique sheet, for the class of "Modifieds" I will have a separate
sheet.


Thanks for the help,
Jared