Microsoft Office Forums - View Single Post - Joining Tables with Index and Match for cell content with >256 characters

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

View Single Post

Old

07-23-2018, 12:54 PM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Try changing fomrula to:

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

Reply With Quote