software

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 quot;sheetsquot; 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--
Leach
------------------------------------------------------------------------
Leach's Profile: www.excelforum.com/member.php...oamp;userid=33830
View this thread: www.excelforum.com/showthread...hreadid=536069The glitch in what appears to be a simple VLookup task is the statement
quot;look through the sheet predetermined for the car typequot;. 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
quot;Leachquot; gt; wrote in
message ...
gt;
gt; Hello All,
gt;
gt; I am wondering if anyone has any ideas I can do to complete a project.
gt;
gt; What I am making are some databases that are payout sheets for a
gt; racetrack that I work for.
gt;
gt; I have 4 types of cars, up to 8 payout sheets and 4 quot;sheetsquot; that list
gt; all the drivers for the current year.
gt;
gt; What I want to be able to do is, when I input the driver number into
gt; the field for the car numbers I want it to look through the sheet
gt; predetermined for the car type, and insert that drivers name into the
gt; space for the name.
gt;
gt; If I am unclear, I am sorry, ask some questions and maybe I could make
gt; it more clear.
gt;
gt; Thanks,
gt; Jared
gt;
gt;
gt; --
gt; Leach
gt; ------------------------------------------------------------------------
gt; Leach's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33830
gt; View this thread: www.excelforum.com/showthread...hreadid=536069
gt;

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 quot;Modifiedsquot; I will have a separate
sheet.Thanks for the help,
Jared--
Leach
------------------------------------------------------------------------
Leach's Profile: www.excelforum.com/member.php...oamp;userid=33830
View this thread: www.excelforum.com/showthread...hreadid=536069