Looking up a value in a row and returning the adjacent cell value.

[dregsy]

Hi,

I would like to be able to lookup a value in a row and return the contents of the cell to the right of it.
For example below, I would like cell D3 to show as 3 (which I think it will), but what I can't work out is how I can get E3 to return "Fred".

Any help anyone can offer would be greatly appreciated.

Thanks.

 

[XcelXpert]

Ah, dregsy, it seems that I was too late to respond, as other people have already found possible answers!

 

[Fluff]

@XcelXpert
Please post your solution as requested.