Need Formulae Help Please

[philmatth]

Sorry but excel isn't my strong point but I'm assuming I need a Look Up for this?

Where the prod_id matches the ID I need the pName to populate pName-full as in the example

I'd much appreciate any help with this please. Thank you.

 

[niceguy_jay]

put this formula in D2

=VLOOKUP($A2,B:C,2,FALSE)

and copy paste it till the last row of column D

 

[philmatth]

Thank you Jay, that worked perfectly!