Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a workbook that is set up that when I enter a specific value ex:e18 in
one cell it will give me the coresponding number ie:800-252-6030 in a different cell. I need to add additonal numbers and "shortcuts" to the workbook. HOW? Please be very specific and step by step |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Click in one of those 'different cells' that takes on a corresponding value.
Chances are there's a formula in that cell that makes reference to cell e18 (maybe a vlookup?). You probably will be able to copy the formula(s) that cause the corresponding values to appear from their current location down to additional rows. If that doesn't get it, please provide some additional information: what sorts of values are entered, what values appear, where is the corresponding data coming from and how is it organized? --Bruce "marybatt" wrote: I have a workbook that is set up that when I enter a specific value ex:e18 in one cell it will give me the coresponding number ie:800-252-6030 in a different cell. I need to add additonal numbers and "shortcuts" to the workbook. HOW? Please be very specific and step by step |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
retrieve cell formatting with IF(HLOOKUP) formula | Excel Worksheet Functions | |||
cell formatting problems | New Users to Excel | |||
Trying to add conditional formatting to every other cell...GOING . | Excel Worksheet Functions |