|In reverse order...|
2 - You can eliminate the #N/A by wrapping an IF function around your VLOOKUP as follows:
If A1 is empty, the formula will return nothing otherwise it will execute the VLOOKUP.
1 - re: if I make mistake in the name it gives me totally different rates!
Please be more specific. What types of "mistake" are you talking about? Obviously Excel can't know that you meant to type in Crow Creek if you type in Crow Park.
You could use a Data validation list made up of the names that are in the table so that you wouldn't have to actually type the name. However, if you choose the wrong name from the list, even Excel can't "fix" that - only you can, by choosing a different name.