Thread: Returning text, date, time, location from one Excel sheet to another
View Single Post
 
Old 06-13-2017, 10:57 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
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.
Reply With Quote