Returning text, date, time, location from one Excel sheet to another

		Microsoft Office Forums > Microsoft Excel > Excel
Returning text, date, time, location from one Excel sheet to another

FAQ

Thread Tools

Display Modes

06-09-2017, 12:31 PM

NBVC

Windows 7 64bit Returning text, date, time, location from one Excel sheet to another

Office 2007

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try:

=IFERROR(INDEX(ATMS!H$2:H$100,MATCH(1,INDEX((ATMS! $B$2:$B$100=G27)*(ATMS!$O$2:$O$100<>""),0),0 )),"")

Note: This is an array formula, and although it doesn't need to be confirmed as a usual array formula, you will need to limit your ranges to defined sizes instead of full columns...

Tags

multple sheet, search column

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:02 AM.