VLookup, Istext combination???

Hello,

I have a mind-bending dilemma (for me at least).

I have two rows of data:

(See attached example)

I need to create a formula in another sheet that searches COLUMN A and populates the cell with data from COLUMN A & B, ONLY IF COLUMN A contains data.

Is this possible and how?

Rod