Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2017, 04:47 AM
NBVC's Avatar
NBVC NBVC is offline Returning text, date, time, location from one Excel sheet to another Windows 7 64bit Returning text, date, time, location from one Excel sheet to another Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

My forrmula above should do that.



It returns the value from column H for each employee in column G of the Quals sheet (starting at G27) where there is a date in column O of ATMS sheet. Enter the formula in Quals!J27 and copy down.

to get Titles from ATMS sheet, change the (INDEX(ATMS!H$2:H$100 part of the formula to (INDEX(ATMS!I$2:I$100
Reply With Quote
Reply

Tags
multple sheet, search column



Similar Threads
Thread Thread Starter Forum Replies Last Post
OneNote on Android phone View Tags? Enter Date, Time, Date & Time DrTwinkyEsq OneNote 0 03-27-2017 07:54 PM
Returning text, date, time, location from one Excel sheet to another Expiry Date Excel sheet! Emperor Excel Programming 6 10-27-2015 11:50 PM
Returning text, date, time, location from one Excel sheet to another Excel 2013 – need help extracting date and time from text cell plus more. Art Mann Excel 1 07-18-2014 09:55 PM
How do you get the DATE and TIME fields to be included in an export to Excel? tpieples Outlook 0 02-18-2013 12:11 PM
Anyway to determine time/date of text creation? pureride Word 1 01-05-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:03 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