Excel Help - Lookup function?

[Betty]

It works - sort of. sigh.

I used the example above that included the false statement as it was giving weird data that was corrected by that.

However, about 180 lines down, I start getting #N/A errors. I thought at first that the address sheet had a slightly different version of the name in column A as the program has been known to cut off names when exporting. And if fact, that did fix one or two lines of the error. However, at line 182, I go to nothing but #N/A's from there on down.

I went so far as to copy and paste the name from the one tab into the other just to verify that the name was exact. Made no change. If I remove the "false" notation from the end of the formula, I get "Ladera Ranch" down the page instead of the n/a error. Ladera Ranch is a city on the spreadhsheet but is not the city mentioned when the error starts.

ARGH!

I love excel - but hate the program I'm using to do the export which is full of little sniggly issues that come up when I least expect them.