IF Cell A1 = Home, Cell A2 should change to 123

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 29 May 2008 09:25 GMT

Hi All,

I’m 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)

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

Regards,
Chris

Reply to this Message

Pete_UK - 29 May 2008 09:36 GMT

What you should do is to list all possible Office locations and the
server name you want to associate with each. Put this in a table
somewhere - suppose it occupies X1:Y10.

Then in C3, with the office location in A3, you can put this formula:

=VLOOKUP(A3,X$1:Y$10,2,0)

This can be copied down if you have other office locations in column
A.

Hope this helps.

Pete

> Hi All,
>
[quoted text clipped - 7 lines]
> Regards,
> Chris

Reply to this Message

Chris - 29 May 2008 10:19 GMT

Thanks Pete,

This worked a treat!

> What you should do is to list all possible Office locations and the
> server name you want to associate with each. Put this in a table
[quoted text clipped - 22 lines]
> > Regards,
> > Chris

Reply to this Message

Pete_UK - 29 May 2008 10:47 GMT

You're welcome, Chris - thanks for feeding back.

Pete

> Thanks Pete,
>
[quoted text clipped - 28 lines]
>
> - Show quoted text -

Reply to this Message