Have a Yes/No show up based on table data

[SpeedyKevin]

Morning all!

Was working on an excel spreadsheet and could use your help please!

Based on the table below, is there a function I could use to populate another cell with either "Yes" or "No" depending on the table's data?

More specifically I have two separate sheets that are populated with data based on their Session (bolded below). I would like to be able to populate a cell on those sheets with Yes or No if there is at least one row/user that has a Yes in the Code column (Based on specific Session # too). If it's blank, I'd like it to place No instead.

Is that possible? I tried using something based on index and match but that only worked on the top most row of the session.

Thanks!
Kevin




[TABLE="width: 778"]
<tbody>[TR]
[TD]First Name:[/TD]
[TD]Last Name:[/TD]
[TD]E-mail:[/TD]
[TD]Phone:[/TD]
[TD]Session[/TD]
[TD]Contact Status:[/TD]
[TD]Primary Confirmed[/TD]
[TD]Alternate Confirmed[/TD]
[TD]Profile:[/TD]
[TD]Team[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]NAME[/TD]
[TD]123@yahoo.com[/TD]
[TD](123)456-7899[/TD]
[TD]1[/TD]
[TD]Qualified[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]NAME[/TD]
[TD]456@yahoo.com[/TD]
[TD](123)456-7899[/TD]
[TD]1[/TD]
[TD]Qualified[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]NAME[/TD]
[TD]123@yahoo.com[/TD]
[TD](123)456-7899[/TD]
[TD]2[/TD]
[TD]Qualified[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NAME[/TD]
[TD]NAME[/TD]
[TD]123@yahoo.com[/TD]
[TD](123)456-7899[/TD]
[TD]2[/TD]
[TD]Qualified[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]X[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Steve_]

I feel like you need a macro.

 

[DanteAmor]

But which column do you want to fill?
Are the 2 sheets related?
In your example, what is the expected result, 4 Yes in the "Code" column, or 4 yes in another column?