Thread: Returning text, date, time, location from one Excel sheet to another
View Single Post
 
Old 06-08-2017, 10:11 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
Try:

=IFERROR(INDEX('ATMS'!H:H,MATCH($G2,'ATMS'!$B:$B,0 )),"")

copied down.

Repeat similar formula for I, M, N by replacing the INDEX range
Reply With Quote