Help with IF function with Matching

[Lyryx]

I need to make a formula that will check to see if a client's name is part of a range of data and then return the value "Township" if they match. If they don't the value should return a blank. To do this I've used an IF statement and took the cells I was checking against and converted them into a named range.

I've been using the formula =If(D3=TownshipConsumers,"Township","") however this only returns the top value of the named range, rather than checking all of the value's of the named range.

If anyone can tell me what I am doing wrong here that would be greatly appreciated. Thank you.

 

[Lyryx]

I've also tried =If(Vlookup(D3,TownshipConsumers,1,True),"Township","") but it is returning a #Value! message.


Nevermind I figured it out, My issue came from the Vlookup returning a value of False if the information wasn't included in the range.
So I added an ISERROR to the formula making it look like this.

=IF(ISERROR(VLOOKUP(D3,TownshipConsumers,1,True)),"","Township")

 

[Lyryx]

Nevermind... this formula is now populating the list with township no matter what information is entered.

 

[Lyryx]

This one works. Sorry for bumping my thread. But to anyone passing by. This is the correct formula.
=IF(ISNA(VLOOKUP(D3,RelatedConsumers,1,FALSE)),"","Related")

 

[kalfit01]

This one works. Sorry for bumping my thread. But to anyone passing by. This is the correct formula.
=IF(ISNA(VLOOKUP(D3,RelatedConsumers,1,FALSE)),"","Related")

I am trying to do something similar.

I need to insert the appropriate name to the assigned # from one spreadsheet to the next. I'll see if this will work for me. thanks.