How to give specific text result in excel table?

Dear Experts,

I have an excel table which I want to give the text note "Yes" in unique based the the table of sequence number without duplicate.
Column D is the result of txt note that I want. And column G is the reference of the sequence number that use for giving the text note.
And I hope the formula can be used in excel 2019.

Thank you!

So you have shown all rows containing 38 with Yes against them - is that the result you want? Because I don't quite see how that matches your description.

Please explain the logic again.

To get what you have shown:

=IF(INDEX($F$2:$F$6,MATCH(C2,$G$2:$G$6,0))=1,"Yes","")

Dear Ali,

Thank you so much for your response. And My apologies for not giving a clear explanation.
If u see the column "G" is the sequence number which is 38 is the first priority to show "Yes", if there is no size "38" in the list, then following by 39. And each code has different colors, each color and size show only "Yes" one time which based on the sequence number in column G.

Thank you!

That didn't make any sense to me. Sorry. Give a few concrete examples.

For example, this one:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D
348	1NSA0439671	Dark Blue	36	Yes

Sheet: Sheet1

36 isn't even on the lookup list ...

Are your expected results correct?

I'm not going to reverse engineer a formula - sorry. If you can't explain it clearly and answer my specific question, then I am not gouing to be able to help.

What does that mean?

Why would you get Yes on that row when 36 is not in the lookup list? The answer is NOT "could be" - I would need a clear explanation. Is that row correct or not - yes or no?

ok, then say if the size is not in the list, then just show blank.
Thank you!

So the expected results are not correct? OK.

With that admitted, I now understand what needs to happen, but I can't offer a 2019-friendly version of the formula - sorry. Someone else will, hopefully.

I can do it with a helper column (could be hidden).

Helper:

=IFNA(INDEX($F$2:$F$6,MATCH(C2,$G$2:$G$6,0)),"")

Formula:

=IFNA(IF(INDEX($G$2:$G$6,MATCH(MINIFS(I:I,A:A,A2,B:B,B2),$F$2:$F$6,0))=C2,"Yes",""),"")

Seen, but no reply ...

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Hi Ali,

My sincere apologies as I was busy.
Thank you for much for your solution. And it's helped me lots.
Thank you!
Have a good day!

Thank you so much!
It works perfectly.

You're welcome.

Administrative Note re. Forum Guideline #2:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter and rarely necessary.

If you are responding out of sequence, it is usually enough just to mention the helper's user name (e.g @AliGW).

If you do need to quote, limit the quoted section just to the section to which you wish to draw your helper's attention or a direct question to which you wish to respond.

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.