Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-15-2011, 11:50 AM
newton.rogers newton.rogers is offline lookup dates and return corresponding data Windows XP lookup dates and return corresponding data Office 2003
Novice
lookup dates and return corresponding data
 
Join Date: Aug 2011
Location: Newcastle
Posts: 6
newton.rogers is on a distinguished road
Default lookup dates and return corresponding data


Columns A - "In date" B - "Out Date" & C contains the the "Networkdays",
column d is a gap column, column e is the Start date column and column f is the End date column, column g a gap column and columns H, I and J the returned data. I hope this makes sense. I have got a little further in solving this by using advanced filtering but is there any other method one could use by only using formulas?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup dates and return corresponding data LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM
Multi-Variable Lookup help ebolton Excel 8 05-05-2011 05:28 AM
lookup dates and return corresponding data Lookup a value from non-sorted data udea Excel 12 04-25-2011 04:34 AM
lookup dates and return corresponding data Using the LOOKUP Command Grapejuice Excel 2 10-15-2008 02:02 PM
Help with Max or lookup fomula to return a name forAmaxValue dutch4fire23 Excel 0 07-28-2006 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft