=TEXTJOIN(CHAR(10), TRUE,
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 7), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 11), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 13), "") )offset of +13 works but if change this
=TEXTJOIN(CHAR(10), TRUE,
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 7), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 11), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 15), "")
)
+15 offset is not working its giving me incorrect data what should i do its forming a loop not even matching with L4 just gives L14 value
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 7), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 11), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 13), "") )offset of +13 works but if change this
=TEXTJOIN(CHAR(10), TRUE,
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 7), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 11), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH('Raw Data'!L4, 'Raw Data'!L:L, 0) + 15), "")
)
+15 offset is not working its giving me incorrect data what should i do its forming a loop not even matching with L4 just gives L14 value