IF AND VLOOKUP function with two variable inputs and three outcomes

[PeanutHead]

Hi there, I wonder if you guys can help me crack this issue I’m having, which shouldn’t be difficult, but I can’t see the wood for the trees any more.

Basically, I have two different dropdowns in my sheet, and I want them to provide three different outcomes as follows:

If the first dropdown reads “Yes” and the second dropdown is one of a selection of items from the second dropdown, then the outcome is “Yes”
If the first dropdown reads “No”, then the outcome (regardless of the second dropdown) is “No”
Everything else is “TBC”

The formula I’m currently using is this. It sometimes works, but I think I’ve got the phrasing wrong and I can’t seem to get my eyes to freshen on it:
=IF(AND(A2="yes", AND(B2=F3:F5))),"Confirmed", IF(A2="No","No","TBC"))

I previously had this working with a large nested IF function, but I need to simplify it for futureproofing! I feel like I am so close to cracking it, but can’t quite get it right. I suspect I need to use a VLookup, but I’ve tried and not managed it. Any suggestions?

Project Management Workbook 2 (Macro Version).xlsm
	A	B	C	D	E	F	G
1	Input 1	Input 2	Outcome		Dropdown1	Dropdown 2
2	No	TBC	#VALUE!		Yes	TBC
3					No	Role 1
4					TBC	Role 2
5						Role 3
6
7
8
Sheet1 (2)

Cell Formulas
Range	Formula
C2	C2	=IF(AND(A2="yes",AND(B2=F3:F5)),"Confirmed", IF(A2="No","No","TBC"))

Cells with Data Validation
Cell	Allow	Criteria
A2	List	=$E$2:$E$4
B2	List	=$F$2:$F$5

 

[PeanutHead]

OK guys, I think I solved it pretty easily - know it would occur to me the second I posted! I think it's as follows, but I'm happy to hear from anyone who thinks there's a better way:

=IF(AND(A2="yes",AND(B2<>"TBC",B2<>"")),"Yes",IF(A2="no","no","tbc"))