To check values from two columns and return the value from third one (Vlook up or Index)

[patelr]

Hello all,

I have two different excel sheets. The detail is as shown below.

MAIN WORKSHEET
B1=Site name
B15=Site Location
D16=Site Type (I do not have Site Type in my main worksheet, this is what I am looking for)

SECONDARY WORKSHEET

COLUMN A-has site names
COLUMN C-has site locations
COLUMN CE-has site type (I need to return this result into D16 in my main worksheet)

site name		site location	site type
ruth		here	X1
ruth		there	X2
ruth		near	X3
ralph		here	X4
ralph		there	X5
ralph		near	X6

<tbody>
</tbody>

In Main sheet D16 I want to get the value of column CE( Returning value) checking the values in Column A and column C (Secondary worksheet) which has to be matched with B1 and B15 (main worksheet)

I applied below formula but it didn't work.
=INDEX(Site_type,MATCH(1,(Site_Name=main_jdennis1!B1)*(Site_Loc=main_jdennis1!B15),0))

I will appreciate your help.

Thanks,
Patelr