That's correct. I wrote a4 by mistake. It should be b4 . So when I type in a name from a5 it is returning a number from b4. Something is not working correctly. Also, some cells work ok. but the ones that don't will always return a number from the cell right above the correct cell. I can't believe that I am the only one who has had this problem.
Your right. I didn't put False at the end because I was hoping that just putting a last name would be enough for it to approximate the corresponding number in the cell in the b column next to it. It works sometimes. If I put false at the end of the argument, I have to write exactly what's in the a column cell but it works every time. It's just not forgiving enough to be user friendly.