dropdown list
 

Hi
In "A1" i've got dropdown list witch is reading items from range
"M1:M3000"
I got also some data in range "N1:N3000"
And now what I need to do is display in "B1" data from "N"
corresponding to item from "M"

Example:

In "A1" i'm selecting "99 bottles" which is in "M101" and in "B1" I
need to have "of beer on the wall" which is in "N101"


Of course i can't use macros.

Many thanks
Jakub Owczarski

dropdown list
 

On May 22, 1:48*pm, wrote:
In "A1" i've got dropdown list witch is reading items from range

Of course ther is no witches in my excel sheet :)
(which)

dropdown list
 

On May 22, 11:54 pm, wrote:
On May 22, 1:48 pm, wrote:

In "A1" i've got dropdown list witch is reading items from range

Of course ther is no witches in my excel sheet :)
(which)

try...

=VLOOKUP(A1,M1:N3000,2,FALSE)

Ken Johnson

dropdown list
 

On May 22, 2:11*pm, Ken Johnson wrote:

try...

=VLOOKUP(A1,M1:N3000,2,FALSE)

Ken Johnson

Thank You Ken, It works just fine.

Best regards
Jake