Nested vlookup or nested IFAND function?

Hello Gurus,

I am trying to figure out the formulas to use when I change the Input Site# it gives me the suite count for that particular site based on data in another worksheet.

So I need the suite count based on the data and zeros where there is not suite type.

Attached is a sample of data to help figure out the formula. Hope this makes sense. If not let me know and I will try my best to explain in more detail if I can.

Your help is appreciated.

Thanks.