Ok lets work it out this way. open a New worksheet and do the following

1. In A1 type Title, In B1 Type Author

2. Enter your Data for tiltle i.e. A, B, C, D, E etc etc below Title
3. Enter your data for Author below Author
4. Lets asume you have so far entered Data in the following Range A1:B6

5. Lets keep cell D1, for the user to enter the Code (i.e. A or B or C or
D....)
6. IN Cell E1 Type the Following =Vlookup(D1,$A$2:$B$6,2)
7. Enter the Code (i.e. A or B or C or D....) in Cell D1
Is it working ?




"K11ngy" wrote:

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