multiple functions for one cell?

[dargen5378]

I have tried to set this up and used the help files...no luck

I have a drop down box set up from the data in Column A. what I want is:

When data from A1 is selected from the drop box in in D1, cell E1 will display data from B1. I want it do do the same thing all the way down...any cell from column A results in the same row, but in column B and the result to be in E1.

[NBVC]

Did you try Vlookup ?

e.g.

In column E:

=Vlookup(X1,A:B,2,0)

this will lookup value in X1 in column A and return what's in corresponding cell from column B.

[dargen5378]

I did a copy paste and it is returning #N/A

what is X1?

[NBVC]

X1 was just an example... replace that with the cell reference containing the dropdown menu.

[dargen5378]

Thank you!