thanks for your reply, but this doesn't work for me.does this work for you?
=INDEX(A:A,MATCH("AAA",K:K,0),1)
hi,In B2 and pull down =IF(INDEX($J$2:$K$9,MATCH("AAA",$K$2:$K$9,0),1)=$A2,"AAA","")
thank you.Why not look up the comment by claim number and then test
= IF( VLOOKUP(claim, Table1, 2) = "AAA", "AAA", "" )
[Note: I prefer XLOOKUP and output via dynamic array but that is specific to Excel 365]