I am not getting any result on following formula and need help, all I get is
#N/A

I have the following information

Array table as below

Title Author
A SURBIN
B KING
C KING
D SURBIN


And so on

In the column I want the user to type in say "A" and it will look in array
table and bring back Surbin, same for "D" etc etc

I have sorted A-Z on Title and also tried same with Author but no success


help??

Steve