Hello Everyone, It's been a while...

I have 2 questions, i'm gonna ask the first one now then the second one later.

The Setup: I have an excel workbooke with 2 sheets. The first sheet is
named "Bowl Assembly" and the second sheet is named "Power Unit. In the
sheet "Bowl Assembly" row i has a series of headers and data entry cells.
The cells in 'Bowl Assembly' row i that have values are (cells: i4,5,6 cells:
i9-16 and cells:i19-36) these cells can be empty, or can have the values:
"PUEP 2" "PUEP 3" to "PUEP 12". These fields are completed by me for data
entry. The fields directly to the right lists a company. for example, cell
'Bowl Assembly'i4 = PUEP 11 the cell directly to the right may = "Company A"

The second sheet "Power Unit" has a list starting at A4, with the terms
"PUEP 2" to "PUEP 12". What I want is the cells directly to the right to
have the value directly to the right in the sheet 'Bowl Assembly'

Example: 'Bowl Assembly'i14 = PUEP 9 and 'Bowl Assembly' j14 = Company A
As stated, the PUEP's are listed in sheet 'Power Unit' so, in sheet 'Power
Unit' a11 there is a value of "PUEP 9" I want 'Power Unit' b11 to equal
"Company A"

If someoene could help me with this if/then scenario it would be appreciated.

Thanks,
Kevin