Vlookup Not Working

[Groovy Chick]

Hi, I have two tabs on a spreadsheet called LOPC and Tiers. From the LOPC file I have a formula that looks at the value in cell A2 and so on to find a match in column A on the Tiers tab and return the text in column C at the Tiers tab if it finds a match or no match if it doesn't. I am using the formula

=IFERROR(VLOOKUP(A2,Tiers!A2:C443,3,FALSE),"No Match")

This works insomuch as it returns No Match but it is returning No Match even when there is a match. Can someone advise me what I am doing wrong? Thank you.

 

[Groovy Chick]

You are welcome.
Glad we were able to help.