| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Cell A1 = Home, Cell A2 should change to 123
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Cell A1 = Home, Cell A2 should change to 123
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 On May 29, 9:25*am, Chris wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Cell A1 = Home, Cell A2 should change to 123
Thanks Pete,
This worked a treat! "Pete_UK" wrote: 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 On May 29, 9:25 am, Chris wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Cell A1 = Home, Cell A2 should change to 123
You're welcome, Chris - thanks for feeding back.
Pete On May 29, 10:19*am, Chris wrote: Thanks Pete, This worked a treat! "Pete_UK" wrote: 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 On May 29, 9:25 am, Chris wrote: 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- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to make the home key always go back to same cell? | Excel Discussion (Misc queries) | |||
| Comments positioning relative to cell not worksheet home | Excel Discussion (Misc queries) | |||
| Control + Home to get to A1 cell | Excel Discussion (Misc queries) | |||
| How can i set-up home key go to a particular cell? | Setting up and Configuration of Excel | |||
| Need fast way to move from cell to home | Excel Discussion (Misc queries) | |||
Linear Mode
