Microsoft Office Forums - View Single Post - Returning text, date, time, location from one Excel sheet to another

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

View Single Post

Old

06-13-2017, 07:35 AM

dave57

dave57 is offline

dave57 uses Windows 7 64bit

Windows 7 64bit dave57 uses Office 2010 64bit

dave57 uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jun 2017

Posts: 9

dave57 is on a distinguished road

Default

All I changed is the range (10000). Excel returned a 0 (zero) in the cell
=IFERROR(INDEX(ATMS!I$2:I$10000,MATCH(1,INDEX((ATM S!$B$2:$B$10000=G27)*(ATMS!$O$2:$O$10000<>""),0),0 )),"")

Reply With Quote