Pull data from other tab - vlook? indexmatchmatch?

I would like to capture the "Ins" from Sheet2 and paste it in Sheet1 under the column "Ins"

I tried to use vlookup but I'm not sure how to write the formula to specify 3 things in order to get the "Ins" data.

For example, the end result should look like this in sheet1:
Ins
Thomasville | Company - H&C | 0X0 | 0| 1| 0| 1| 0 <--- the last column is what I need filled in from Sheet2 (the column is green in sheet1 and blue in sheet2)

row 73 (sheet1);
Bentonville | Drive To Your Door | 10x10 | 66 | 7 | 0 | 73 | 3 <--- 3 is what I need pasted in Sheet1 from Sheet2.

I hope this is clear to understand. I've attached a excel sample of the above.

I appreciate everyone's help here.