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