Hi all -again
Well, I have tried everything

Last formula is below and also the tables bit no luck so far?

=VLOOKUP(E20,author,2)

Title result Title Author
A #N/A A Jordan
B B morate
C C Jordan
D D Jordan
E E surbin
F F surbin
G G morate
H H morate
I I morate
J J morate




"claude jerry" wrote:

give us your formula, (the formula you have in your cell which shows #NA)

"K11ngy" wrote:

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