Populate cells using multiple column lookup

[Andelousiano]

Hi,

I would like to be able to populate a column by matching up values from two columns on a different sheet.

Basically I have one sheet with these columns

Year Barrel Tree

The year and barrel columns have data in them.

I have another sheet with a key to what tree was in each barrel number for each year. So it also has columns for Year, Barrel, and Tree which are all filled with data.

I would like to put a formula in the tree column in worksheet 1 that puts the correct tree species according to the year and barrel in worksheet 2.

I combined the Year/Barrel columns into one column to give each combination a unique identifier if that makes it easier. I did a lookup function that sort of worked, but some of the trees are wrong, so it's not doing exactly what I want and I'm not sure why.

How would you do this?

Thanks!

Marc

[Gatti]

Could you please post your workbook?

[Andelousiano]

Sorry, how do I do that. I'm not seeing anything for attaching files to posts.

[Gatti]

Click on "Go Advanced" instead of "Quick Reply", then click on Attachments (beside the Smile, at the first row of commands)

[Andelousiano]

BarrelData.xlsx

Hopefully that worked

[Andelousiano]

Actually use this one. I changed the column names to reflect the names I used in my original post.

[Gatti]

Try this on RawData Worksheet Cell D3:

Please Login or Register  to view this content.

Is that what you need? Give me a feedback

[Andelousiano]

That seems to have worked. Thanks so much!!

[Gatti]

That seems to have worked. Thanks so much!!

Thats great!

If possible, Add Reputation and mark your thread as [SOLVED]