Newbie question - sorry in advance

[rdraper]

I apologize in advance for a newbie question (but im learning )

I have a worksheet with around 10,000 line items, about 2000 of them are the same or similar item, yet are all over the sheet and not in order. Is it possible to do a "Find" or a "Find / Replace" for an item say in Column E and then have a value inserted in Column K.

Example.... in my worksheet in column E i have alot of items with the product number 1217-05. I would like to be able to assign the value "60" in column K to every row with the value of 1217-05 in column E.
(i hope that made sense) ... anyway is this possible to do without going thru a "Find All" and then manually entering the value in each row for column k?

Thanks in advance

 

[VoG]

Hello. In K1 copied down

=IF(C1="1217-05",60,"")

 

[stilesbn]

Actually you'll want to copy it into column K right? and the formula should reference column E like this.

=IF(E1="1217-05",60,"")

 

[rdraper]

Ok...im still confused or i didnt explain well....sorry. my example below:
Lets take my column E and say all the rows that have "1217-15-500" in them (and I have roughly 1500 rows containing this value in column E in this worksheet of 10000 rows) in any row of Column E where value is 1217-15-500, I would like to have the value 60 entered in that row, Column K.
I hope that helped.

E
1217-15-500
1217-20-500
1217-15-500
1217-30-500
1365-53-000
1219-36-056
1217-15-500
1570-02-110

 

[stilesbn]

Then you need this formula.

=IF(E1="1217-15-500",60,"")

Copy and paste that formula into cell K1 and then autofill it down to the end of your data.

 

[jrthomas81]

Stiles had it right except you didn't give him enough information. Enter the following formula in Column K all of the way down the worksheet for every row that has information on it.

=IF(E1="1217-05-500",60,"")

Actually you'll want to copy it into column K right? and the formula should reference column E like this.

=IF(E1="1217-05",60,"")

Ok...im still confused or i didnt explain well....sorry. my example below:
Lets take my column E and say all the rows that have "1217-15-500" in them (and I have roughly 1500 rows containing this value in column E in this worksheet of 10000 rows) in any row of Column E where value is 1217-15-500, I would like to have the value 60 entered in that row, Column K.
I hope that helped.

E
1217-15-500
1217-20-500
1217-15-500
1217-30-500
1365-53-000
1219-36-056
1217-15-500
1570-02-110