Auto-populate based on text in same row

I'm looking for a code that will auto-populate information. Similar to vLookup, attach is a piece of data to illustrate what I'm looking for.

Desire actions
1. Create 3 columns
2. Name the 3 new columns (PMO First Name, PMO Sig Title, and PMO Email) respectively
3. Based on column "E" the Primary PMO Contact , autopopulate or fill the specific columns to the right.

Primary PMO Contact |PMO First Name |PMO Sig Title |PMO Email
Carmen Peach |Carmen |Project Specialist |[email protected]
Kirstin Grape |Kirstin |Project Lead |[email protected]
Mark Banana |Mark |Head Project |[email protected]
Renee Orange |Renee |Admin |[email protected]

SampleData.xls

Please let me know If I'm not clear with what I'm stating. Thanks!

Is this possible in VBA?

Any ideas?

Bump bump.

Still need help. Thanks!