If or Vlookup? need help please

Originally Posted by itshewe

I have tried to insert your solutions but either the formula gives a wrong error or i get "#N/A" sign.

You need to adjust the syntax because what you've got in your spreadsheet is laid out differently than the sample picture.

For example:

=IF( COUNTIFS(Sheet2!$A$2:$A$5289, $B$2, Sheet2!$C$2:$C$5289, $B8) > 0, "ANNOUNCEMENT", "")

In D8 and pull down.

This worked exactly as it was supposed to... based on my understanding of your needs, at any rate.

BTW, the company for stock code 8135 is "ZMFY AUTOMOBILE" on sheet1 and "ZMFY Glass" on sheet2.

Being new I really do not know how to upload a file on this forum...

Click "Go Advanced" button (or Alt+X)
Additional Options: Attachments: "Manage Attachments" button
Navigate folders & select file(s)
Click attach



EDIT:
ah, ninja'd