Jump to content
By fans, for fans. By fans, for fans. By fans, for fans.

Excel Question

charlie clown

Recommended Posts

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?

Link to comment
Share on other sites

If I'm reading this correctly and you've already done the drop down, why can't you do this with a VLOOKUP?


The formula in Column N (for row 1) in Leaf would be:




And then just fill down.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...