I was able to set my sheet up to do what I was wanting with the following Lookup Formula.

=LOOKUP(D4,FMs!A:A,FMs!B:B)


I am having one small glitch though, and wondered if anyone might now how to fix it.


D4 is my cell that provides the information to be looked up. If a name is typed into D4 that can be found in A:A....it provides the correct number for this contact.

the problem is that if a name is typed in that does not match "exactly" to a name listed in A:A....I am still getting a number pulled, and pretty random.

Is there a way to correct this formula.....so that if the data typed in D4 does not match exactly what is in A:A, it will just return an error or some other message ????