Multiple if statements - issues

[bluepenink]

All

I am having issues with embedding multiple if scenarios with OR/and logic.

In sheet1, column A = system titles
in sheet 1, column B = # of years
in sheet1, column C = if statement required (client titles)

in reference sheet, column A = system titles
in reference sheet, column B = client titles

it seems like a pretty simple, vlookup, however, there are couple of issues

a) if system title = Local Partner OR Principal OR Principal Economist OR Principal TaxAdvisor AND their # of years > 10 THEN column C in sheet1 = Sr Partner
b) if system title = Local Partner OR Principal OR Principal Economist OR Principal TaxAdvisor AND their # of years < 10 THEN column C in sheet1 = Partner
c) If none of A or B, then vlookup sheet1 column A to reference sheet columns A:B

How can I embed the logic above? I am confused! thxs so much!

 

[wideboydixon]

Book1
	A	B	C
1	system title	# of years	client title
2	Local Partner	9	Partner
3	Principal	11	Sr Partner
4	Principal Economist	9	Partner
5	Principal TaxAdvisor	11	Sr Partner
6	Something	10	Else
Sheet1

Cell Formulas
Range	Formula
C2	=IF(ISNUMBER(MATCH($A2,{"Local Partner","Principal","Principal Economist","Principal TaxAdvisor"},0)),IF($B2>10,"Sr Partner","Partner"),VLOOKUP($A2,Sheet2!$A:$B,2,FALSE))

Book1
	A	B
1	system title	client title
2	Something	Else
Sheet2

WBD

 

[bluepenink]

awesome thnk you