Lookup data from one column, replace found data in from another..

Hi All,

Have been searching for something to deal with this which I am sure is really simple, but I can't get my head around it.

I have two sheets:

Data
Lookup

In Data is a list of IP addresses in two columns...source and destination.

For both columns, i'd like the IP addresses to be replaced with the corresponding name in the Lookup sheet.

See the attached as an example...I've included a sheet which shows what I expect to be returned.

I'm sure its a simple Vlookup or something but not sure how that works if you want it to replace the contents of the original cell.. Or would it need to go into a new worksheet?

Hope someone can help!

Thanks vlady,

That seems to almost do what I need, however If i fill down the data sheet, I can't pull down the formula's in new sheet? Comes up with N/A

It needs to be versatile enough for me to put a whole list of information into the lookup sheet, and then each cell should check against that info.

I assume you would need to use $ values when specifying the data/lookup table?

Wonder if you could automate this with a macro of some sort.