Hi

You can do it, using INDEX&MATCH or VLOOKUP functions.