LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Liz Steffen
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tricky ... Pullout related rows that match a single word using Vlookup YJL Excel Discussion (Misc queries) 18 November 14th 05 08:22 AM
can vlookup be forced to make a case sensitive match? alan Excel Discussion (Misc queries) 1 September 22nd 05 12:59 PM
Match function...random search? Les Excel Worksheet Functions 10 July 28th 05 11:54 AM
is there a way to search with vlookup to match more than 1 column puppy Excel Discussion (Misc queries) 7 June 30th 05 07:41 PM
How to match two different cells text, if the text is not in the . LEsa Excel Worksheet Functions 1 March 13th 05 02:46 AM


All times are GMT +1. The time now is 01:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"