Not sure if I'm using IF(OR(VLOOKUP(IFNA functions correctly?

[CorgiDog123]

Hello everyone,

https://imgur.com/a/0r4JGFn









This is a sample spreadsheet but.. Is it possible for column Snowball to display a 1 when it meets the criteria and 0 when it doesn't? Likewise, can Douglas display a 1 when it does and a 0 when it doesn't? The biggest issue I have is that I need to add a ISNA function so that when a N/A pops up, it turns into a 0 instead.
Right now, on those 2 N/A cells, I have
=IF(OR(VLOOKUP(I11,D:F,3,FALSE)="Douglas"),"1","0")
But it doesn't seem to work. Thanks and let me know if I can clarify better.

 

[Aladin Akyurek]

Try to post the data and/or the formulas that you have directly here in the forum.