multiple database lookup
 

I'm getting myself totally tied in knots over this one.
Database sheet holding: order number, workstation, date, operator, quantity
produced.

An order may take up several days of production at the same workstation,
sometimes on two shifts.
On a separate sheet I have the list of currently running orders and the
production manager wants to see how many parts were produced by which
operators on the most recent day worked.
A straight lookup based on the order number won't do it because multiple
rows will meet that criteria. I need to get all those rows and then pick out
just the one (or two) operators and quantities for the date nearest today.

Can it be done all in one regular formula or do I need to set up array
formulas or pulling everything into an array in VBA and filtering it there?

I have spent so long staring at this one I need fresh pairs of eyes for some
insight...

--
WinXP - Office2003 (Italian)

multiple database lookup
 

Sounds like you need to create a PivotTable. It would summarize and group all
your data, and you could quickly choose which operator(s) you want to look
at, and which days to display.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"David Macdonald" wrote:

I'm getting myself totally tied in knots over this one.
Database sheet holding: order number, workstation, date, operator, quantity
produced.

An order may take up several days of production at the same workstation,
sometimes on two shifts.
On a separate sheet I have the list of currently running orders and the
production manager wants to see how many parts were produced by which
operators on the most recent day worked.
A straight lookup based on the order number won't do it because multiple
rows will meet that criteria. I need to get all those rows and then pick out
just the one (or two) operators and quantities for the date nearest today.

Can it be done all in one regular formula or do I need to set up array
formulas or pulling everything into an array in VBA and filtering it there?

I have spent so long staring at this one I need fresh pairs of eyes for some
insight...

--
WinXP - Office2003 (Italian)