Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP needing to match two cells
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: Date Shift AvailMin Oper_BreaksOper_StickerMach 2/9/2009 2 480 60 0 5/5/2006 2 480 0 0 5/5/2006 1 480 24 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, Liz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky ... Pullout related rows that match a single word using Vlookup | Excel Discussion (Misc queries) | |||
can vlookup be forced to make a case sensitive match? | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
How to match two different cells text, if the text is not in the . | Excel Worksheet Functions |