One way via VLOOKUP

Put in C4 and copy down to C30:

=VLOOKUP(B4,{"North","Bjorn Rasmussen";"South","Pablo Garcia";"East","Marie
Jones";"West","James Miller"},2,0)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"k f h" wrote in message
...

Hi All,
The Cells B4:B30 contain the text North,South,East,West.
North=Bjorn Rasmussen, South=Pablo Garcia, East=Marie Jones and West=James
Miller. How do I enter the formulae in cell C4 to show the relivant name
with
relivant compass point.

Thanks,

kfh.