Data Validation Combo needs to return a different value

I want to be able to use Data Validation to validate against a List of Names (Places), then once selected use VLOOKUP to get a Post Code. I have a lookup table, something like this;

Postcodes
Home XX1 1YY
Office XX2 1YY
Post Office YY3 1AB
Pizza House ZZ 4 5SS

So my Data Validation List would present me with Home, Office, Post Office etc., but when I select it the cell gets the Post Code. I hope that makes sense.

I am thinking I need to link the output of the Data Validation to a VLOOKUP, whcih could well be a bit of VBA (which I am not that hot on, but I would like to be better at).

Any suggestions/advice would be appreciated.

Thanks in anticipation.

Validation will say Home, Office, .....

and if Office is selected will return XX2 1YY.

Sorry, my original explanation was a little brief, and I think I am hoping for more than can be done.

The Post Code fits in one cell, and I was hoping that once the selection had been made, the cell where the validation is would be overwritten with the Post Code. ie if the Data Validation is on cell A1, I would use the pull down on that cell, select Post Office, then it would come back and display YY3 1AB in cell A1.

Sorry again, for an overly brief question.

Yes, that's why I think this is a fanciful wish. ie probably cannot be done.

Effectively I want the drop down to show one thing, but return another linked thing.