Looking up information from table

Hi again,

I need help how to look up info from a table. Basicly if one cell matches another, look up value accordingly. I've added a sample file that will show my problem

Thanks in advance

Here are three ways...

It's always easy when you know how, having you read those examples and immediately see it as simple is very good, indeed.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.