IF x then VLookup and sum, IF Y then VLookup and sum

Hi guys,

This is my first post here so I hope I'm doing it right and that someone might help me out.

I'm working on a spreadsheet where I insert a bunch of tickers.

I then have a separate spreadsheet where I want to do the following.

lets say, cell A1 =IF (Cell B2=Yes I want it to search a data range for a text value "Peugeot" then I want it to give me the number of times that "Peugeot" comes up) IF (Cell B2=No I want it to search a different data range for the same text value "Peugeot" and give me the number of times that "Peugeot" comes up) if neither one finds "Peugeot" then 0.

I hope I made myself clear.

I appreciate any help that you might give me.

Thanks