![]() |
|
#1
|
||||
|
||||
![]()
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 |
![]() |
Tags |
multple sheet, search column |
|
![]() |
||||
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 |
![]() |
Emperor | Excel Programming | 6 | 10-27-2015 11:50 PM |
![]() |
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 |