software

I have three columns of data. Column A is numbered from 0 to 720. Column
B and C are measured data that I need to shift up or down relative to
Column A. I want the peak value in Column B to line up with a
user-specified value in Column A. If I specify 360, I want the peak
value in Column B to line up with 360 on Column A. If I specify 359, I
want the peak value to line up with 359. However, the data in Column B
and C cannot be sorted or rearranged. The entire range of values must
be shifted up or down.

How can I do it?

I tried searching but found nothing like what I'm trying to do.--
RexAtHighSpeed
------------------------------------------------------------------------
RexAtHighSpeed's Profile: www.excelforum.com/member.php...oamp;userid=29793
View this thread: www.excelforum.com/showthread...hreadid=494977Rex:

This sounds like something you can solve using a =vlookup() formula. The
thing to consider here is the user interface. If you are the user than you
may not care how it looks typing in the number may just be good enough for
you. For smaller ranges I often generate a list based upon the value in
column a and allow the user to only select an item of the predetermined list.

Alan Wyatt has a really good explanation of Vlookup that should get you
going quickly.

exceltips.vitalnews.com/Pages..._Function.html

If you want to create a dropdown list for the user than here's a good link
to look at

www.uis.edu/ctl/training/deta...eldropdown.htm

The disadvantage to list is that the cells the list is based off of has to
be in the same worksheet. Usually I put them on some unused rows and make
the text white so they end up virtually forgotten.

The vlookup() function (without the drop down list) can exist between
worksheets so you can create a worksheet where the user types in the
information and the formulas (one for each cell) will reference the data.
This will give your results a much cleaner appearance.If this doesn't answer your question completely let me know. It should get
you off to the right start.

GOOD LUCK!!

quot;RexAtHighSpeedquot; wrote:

gt;
gt; I have three columns of data. Column A is numbered from 0 to 720. Column
gt; B and C are measured data that I need to shift up or down relative to
gt; Column A. I want the peak value in Column B to line up with a
gt; user-specified value in Column A. If I specify 360, I want the peak
gt; value in Column B to line up with 360 on Column A. If I specify 359, I
gt; want the peak value to line up with 359. However, the data in Column B
gt; and C cannot be sorted or rearranged. The entire range of values must
gt; be shifted up or down.
gt;
gt; How can I do it?
gt;
gt; I tried searching but found nothing like what I'm trying to do.
gt;
gt;
gt; --
gt; RexAtHighSpeed
gt; ------------------------------------------------------------------------
gt; RexAtHighSpeed's Profile: www.excelforum.com/member.php...oamp;userid=29793
gt; View this thread: www.excelforum.com/showthread...hreadid=494977
gt;
gt;