software

I have a worksheet with data. I need to match the date and the shift and
return the value to a summary page.

Sample data:
DateShiftAvailMinOper_BreaksOper_StickerMach
2/9/2009248060 0
5/5/200624800 0
5/5/2006148024 14

So, I need to lookup Date and Shift and return to the cell the available
minutes.

Sheet sample of where data goes to:

5/9/2006
DAILY

Operational
Shift 1 Shift 2
Breaks (value of 24 would go here)
Sticker Machine
Breakdown Infeed
Breakdown Hoist
Infeed Lug Loader
Infeed Moisture Meter
Infeed Tipple
Infeed Table

--
-----
Thank you,
LizIf that 24 is in column D and the sheet name is quot;Sheet1quot;, for example, and if
the date 5/5 is in cell C2 of the Summary sheet, (lots of assumptions!) then
this formula in the Summary sheet would work:
=INDEX(Sheet1!D,MATCH(C2amp;quot;1quot;,Sheet1!A1:A100amp;Shee t1!B1:B100,0))
This formula needs to be ctrl/shift/entered, not simply entered.
the C2amp;quot;1quot; is because C2 contains 5/5/2006 and the quot;1quot; is the shift.
HTH

quot;Liz Steffenquot; wrote:

gt; I have a worksheet with data. I need to match the date and the shift and
gt; return the value to a summary page.
gt;
gt; Sample data:
gt; DateShiftAvailMinOper_BreaksOper_StickerMach
gt; 2/9/2009248060 0
gt; 5/5/200624800 0
gt; 5/5/2006148024 14
gt;
gt; So, I need to lookup Date and Shift and return to the cell the available
gt; minutes.
gt;
gt; Sheet sample of where data goes to:
gt;
gt; 5/9/2006
gt; DAILY
gt;
gt; Operational
gt; Shift 1 Shift 2
gt; Breaks (value of 24 would go here)
gt; Sticker Machine
gt; Breakdown Infeed
gt; Breakdown Hoist
gt; Infeed Lug Loader
gt; Infeed Moisture Meter
gt; Infeed Tipple
gt; Infeed Table
gt;
gt; --
gt; -----
gt; Thank you,
gt; Liz
gt;

=INDEX(Minute_Range,MATCH(1,(Date_Range=lookup1)*( Shift_Range=lookup2),0))

entered with ctrl shift amp; enter--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Liz Steffenquot; gt; wrote in message
...
gt; I have a worksheet with data. I need to match the date and the shift and
gt; return the value to a summary page.
gt;
gt; Sample data:
gt; Date Shift AvailMin Oper_BreaksOper_StickerMach
gt; 2/9/2009 2 480 60 0
gt; 5/5/2006 2 480 0 0
gt; 5/5/2006 1 480 24 14
gt;
gt; So, I need to lookup Date and Shift and return to the cell the available
gt; minutes.
gt;
gt; Sheet sample of where data goes to:
gt;
gt; 5/9/2006
gt; DAILY
gt;
gt; Operational
gt; Shift 1 Shift 2
gt; Breaks (value of 24 would go here)
gt; Sticker Machine
gt; Breakdown Infeed
gt; Breakdown Hoist
gt; Infeed Lug Loader
gt; Infeed Moisture Meter
gt; Infeed Tipple
gt; Infeed Table
gt;
gt; --
gt; -----
gt; Thank you,
gt; Liz
gt;
Hi Bob,

You have been very helpful. Here is my syntax and it's not working.

=INDEX(Header!D,MATCH(A2amp;quot;1quot;,Header!A2:A700amp;Head er!B2:B700,0))

Can you help some more?

--
-----
Thank you,
Liz
quot;Bob Umlas, Excel MVPquot; wrote:

gt; If that 24 is in column D and the sheet name is quot;Sheet1quot;, for example, and if
gt; the date 5/5 is in cell C2 of the Summary sheet, (lots of assumptions!) then
gt; this formula in the Summary sheet would work:
gt; =INDEX(Sheet1!D,MATCH(C2amp;quot;1quot;,Sheet1!A1:A100amp;Shee t1!B1:B100,0))
gt; This formula needs to be ctrl/shift/entered, not simply entered.
gt; the C2amp;quot;1quot; is because C2 contains 5/5/2006 and the quot;1quot; is the shift.
gt; HTH
gt;
gt; quot;Liz Steffenquot; wrote:
gt;
gt; gt; I have a worksheet with data. I need to match the date and the shift and
gt; gt; return the value to a summary page.
gt; gt;
gt; gt; Sample data:
gt; gt; DateShiftAvailMinOper_BreaksOper_StickerMach
gt; gt; 2/9/2009248060 0
gt; gt; 5/5/200624800 0
gt; gt; 5/5/2006148024 14
gt; gt;
gt; gt; So, I need to lookup Date and Shift and return to the cell the available
gt; gt; minutes.
gt; gt;
gt; gt; Sheet sample of where data goes to:
gt; gt;
gt; gt; 5/9/2006
gt; gt; DAILY
gt; gt;
gt; gt; Operational
gt; gt; Shift 1 Shift 2
gt; gt; Breaks (value of 24 would go here)
gt; gt; Sticker Machine
gt; gt; Breakdown Infeed
gt; gt; Breakdown Hoist
gt; gt; Infeed Lug Loader
gt; gt; Infeed Moisture Meter
gt; gt; Infeed Tipple
gt; gt; Infeed Table
gt; gt;
gt; gt; --
gt; gt; -----
gt; gt; Thank you,
gt; gt; Liz
gt; gt;

using 2 worksheets. first is the bid sheet, second is the database.

I need to find a set value from a database which will first lookup a part
number/name and then, depending on an entered letter sequence, return a cost. Think of ordering a car quot;Aquot;, and having options for certain tires. The
letter sequence, lets say quot;t1quot; would return a cost for tires accordingly but
based on only car quot;Aquot;

I first choose a part from a drop down box (col b). in col C a price is
generated via lookup from col B. in col D I might need an assembly item for
that paticular part which comes in several types. In col A I want to enter a
letter sequence which row D will recognize by first matching col B in a
database, then depending on the quot;letter sequecequot; will return a value (cost).
Help