Hi All,

Im doing a spreadsheet where I have a list of Office locations, when I
choose a location I would like the relevant server name to appear in the cell
of my choosing (i.e. C3)

Im not sure how to go about this and was wondering if anyone knows the
formula, or if this is Evan possible?

Regards,
Chris