|
|
#14
06-13-2017, 10:57 AM
|
||||
|
||||
In your original sample file, the people's names were in G and they started in G27, that is why I referenced G27. Here you have the people's names in column A.
So since your first name seems to be in A23, then I would put this formula in G23: =IFERROR(INDEX(ATMS!I$2:I$4961,MATCH(1,INDEX((ATMS !$B$2:$B$4961=A23)*(ATMS!$O$2:$O$4961<>""),0),0 )),"") copied down. 
|
| 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 |
 Expiry Date Excel sheet!
|
Emperor | Excel Programming | 6 | 10-27-2015 11:50 PM |
|
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 |
Windows 7 64bit 
Office 2007
Threaded Mode