dropdown list

[jakub.owczarski]

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

 

[jakub.owczarski]

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

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

 

[Ken Johnson]

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

try...

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

Ken Johnson

 

[jakub.owczarski]

try...

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

Ken Johnson

Thank You Ken, It works just fine.

Best regards
Jake