Thread: Returning text, date, time, location from one Excel sheet to another
View Single Post
 
Old 06-13-2017, 04:47 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit 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