Absolute cell formatting

[marybatt]

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

 

[bpeltzer]

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