software

Here is my scenario, I have in column D either a C or an E. In column C, it
needs to reference column D so the E=1 or C=100. Can anyone shed some light
as to how I can do this without coping the cells because its for a price
change and there are like 7000 rows. Please help!!!

=if(d1=quot;Equot;,1,if(D1=quot;Cquot;,100,quot;Neitherquot;))

If every single cell that you'll reference in col D has either an E or a C,
use

=IF(D1=quot;Equot;,1,100)

quot;Tiffaniquot; wrote:

gt; Here is my scenario, I have in column D either a C or an E. In column C, it
gt; needs to reference column D so the E=1 or C=100. Can anyone shed some light
gt; as to how I can do this without coping the cells because its for a price
gt; change and there are like 7000 rows. Please help!!!

Hi Tiffani

Could you give a little more clarification?I'm not understanding exactly
what you are after.
It's not that you want
=IF(D1=quot;Cquot;,100,IF(D1=quot;Equot;,1,quot;quot;))
is it?

--
Regards

Roger Govierquot;Tiffaniquot; gt; wrote in message
...
gt; Here is my scenario, I have in column D either a C or an E. In column
gt; C, it
gt; needs to reference column D so the E=1 or C=100. Can anyone shed some
gt; light
gt; as to how I can do this without coping the cells because its for a
gt; price
gt; change and there are like 7000 rows. Please help!!!

Tiffani,

I'd use a VLOOKUP table.

Create a small table as follows, somewhere on your worksheet, or in a
separate worksheet in the same workbook if you like. (Each figure is in
a different cell)

C 100
E 1

Then select the range, go to the Insert Menu, Name, and give it a name
(e.g. prices)

In column C (say C2), type the formula =VLOOKUP(D2,prices,2,false)

Fill C2 down your 7000 rows. All price changes will be made.

The advantage of doing it this way is that if you ever have to change
prices again, you just change the VLOOKUP table, and all of the changes
will be made for you.

Hope this helps.

Let me know how it goes.--
random1970
------------------------------------------------------------------------
random1970's Profile: www.excelforum.com/member.php...oamp;userid=32112
View this thread: www.excelforum.com/showthread...hreadid=519323Duke,
Thank you so much. That did it. Here is another question!

This is a price update from excel to our ProTrac program that we use. This
particular one is Pass amp; Seymour and OnQ/Legrand. They are mixed together. Is
there a way we can extract out the OnQ to another worksheet. Or would we just
have to like cut and paste.

When you are looking at the data, is there something that obviously
differentiates one set from the other? If so, you can use Excel's Data-gt;Sort
features to segregate the data into 2 groups. That'd simplify the cutting
and pasting

quot;Tiffaniquot; wrote:

gt; Duke,
gt; Thank you so much. That did it. Here is another question!
gt;
gt; This is a price update from excel to our ProTrac program that we use. This
gt; particular one is Pass amp; Seymour and OnQ/Legrand. They are mixed together. Is
gt; there a way we can extract out the OnQ to another worksheet. Or would we just
gt; have to like cut and paste.