Excel Question

[charlie clown]

So I have a worksheet 'Trees' with a list of data

 

Column A / Column B

1 / oak

2 / ash

3 / elm

4 / beech

 

And I have a second worksheet 'Leaf' which has data validated against the list in 'Trees'

 

So in Column M of worksheet Leaf I can pick from a drop down entry 1, 2, 3 or 4 (i.e. column M is validated from the list in Trees Column A)

 

I would like column N of worksheet Leaf to automatically populate with the values from Column B of Trees, based on the entry selected in Column M of Leaf.

 

Is this possible? What function or formula do I need?

[Behind Enemy Lines]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Senrab_nhoj]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[PhilM]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited October 20, 2014 by charlie clown