Joining Tables with Index and Match for cell content with >256 characters

		Microsoft Office Forums > Microsoft Excel > Excel
Joining Tables with Index and Match for cell content with >256 characters

07-23-2018, 12:54 PM

NBVC

Windows 10 Joining Tables with Index and Match for cell content with >256 characters

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try changing fomrula to:

=INDEX('Female Answers'!$A$2:$B$2203,MATCH(TRUE,INDEX('Female Answers'!$B$2:$B$2203=$C2,0),0),2)

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM
Translate INDEX(MATCH) into VBA	grexcelman	Excel Programming	1	03-08-2015 05:06 PM
Index match vba	grexcelman	Excel	0	03-05-2015 10:55 PM
Index Match syntax	grexcelman	Excel Programming	0	03-05-2015 07:17 AM
UDF multiple IFs INDEX-MATCH	grexcelman	Excel Programming	0	02-22-2015 04:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:07 AM.