lookup list then display certain text

[aarona]

Hi I'm trying to create a macro, I want excel to lookup the value in C1 and check if it matches with the list in Column A

If the value in C1 matches the list in Column A, I want B1 to have the text of "QC" and if there is no match B1 will display "No-QC"

Anyone can help me with this?

Thanks in advance.

[PFDave]

enter this in B1:

Please Login or Register  to view this content.

[aarona]

Thanks dave, however it displays #Name?

[PFDave]

What version of Excel are you using?

Maybe change the IFNA to IFERROR as below:

Please Login or Register  to view this content.

[aarona]

Yeah that fixed the problem, I'm using 2010 thanks btw.

[PFDave]

As it says in you user profile! Should have spotted that! Glad its sorted and thanks for the rep.