Excel query

[Swetha85]

=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

 

[p45cal]

Seems fine here. If L4 is the first instance of its value in column L that second fomula should return the contents of cells C11, C15 & C19.
If it doesn't then there may be a similar value to L4's value above row 4 in column L.
Best attach a copy of the workbook, and if it contains sensitive data, strip it down to just the sheet(s) concerned and the columns concerned, making sure it still gives incorrect results.

Just had a thought; the fact that the formula contains a full reference to a sheet implies that the fomula isn't in the Raw Data sheet. Not only that, but ALL references in that formula are for the Raw Data sheet, so it makes me wonder if one of those references shouldn't be for the Raw Data sheet, but for a cell on the same sheet that the formula is in. So this is a guess:
=TEXTJOIN(CHAR(10), TRUE,
IFERROR(INDEX('Raw Data'!C:C, MATCH(L4, 'Raw Data'!L:L, 0) + 7), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH(L4, 'Raw Data'!L:L, 0) + 11), ""),
IFERROR(INDEX('Raw Data'!C:C, MATCH(L4, 'Raw Data'!L:L, 0) + 15), ""))

 

[pecoflyer]

Crosspost https://www.excelforum.com/office-365/1426533-regarding-offset-issue-in-excel.html

 

[vletm]

Swetha85​

As You've read from Forum Rules:

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

These are for everyone.