Find and replace
 

I have a table with 6 columns, A to F. Column A contains unique item
numbers. Column B contains descriptions of those items. Columns C-F
contain a random listing of the numbers from column A.

I want to replace the random listings of items in C-F with the
descriptions of the items from column B.

There are 1300 items. Can I do this without running 1300 Find and
Replaces?

I would be happy with four new columns added that have the descriptions
for the random items in C-F in the same order (not exactly a replace).

Thanks!

Al

Find and replace
 

In G1 put this and copy down
=VLOOKUP(C1,A:B,2,FALSE)
In H1 put this and copy down
=VLOOKUP(D1,A:B,2,FALSE)
In I1 put this and copy down
=VLOOKUP(E1,A:B,2,FALSE)
In J1 put this and copy down
=VLOOKUP(F1,A:B,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



" wrote:

I have a table with 6 columns, A to F. Column A contains unique item
numbers. Column B contains descriptions of those items. Columns C-F
contain a random listing of the numbers from column A.

I want to replace the random listings of items in C-F with the
descriptions of the items from column B.

There are 1300 items. Can I do this without running 1300 Find and
Replaces?

I would be happy with four new columns added that have the descriptions
for the random items in C-F in the same order (not exactly a replace).

Thanks!

Al

Find and replace
 

If I understand you, then in Cell C2 enter =$B2
Copy C2 to D2:F2,
then Copy C2:F2 down to C3:C1301;

Again, if I understand your Q;
If this works then additionally,
You may want to Copy C2:F1301, and Paste-Special - as Values
to blow away the formulas leaving constants / values.



" wrote:

I have a table with 6 columns, A to F. Column A contains unique item
numbers. Column B contains descriptions of those items. Columns C-F
contain a random listing of the numbers from column A.

I want to replace the random listings of items in C-F with the
descriptions of the items from column B.

There are 1300 items. Can I do this without running 1300 Find and
Replaces?

I would be happy with four new columns added that have the descriptions
for the random items in C-F in the same order (not exactly a replace).

Thanks!

Al

Find and replace
 

Great! This saved me hundreds of hours over the next year!

Al

CLR wrote:
In G1 put this and copy down
=VLOOKUP(C1,A:B,2,FALSE)
In H1 put this and copy down
=VLOOKUP(D1,A:B,2,FALSE)
In I1 put this and copy down
=VLOOKUP(E1,A:B,2,FALSE)
In J1 put this and copy down
=VLOOKUP(F1,A:B,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



" wrote:

I have a table with 6 columns, A to F. Column A contains unique item
numbers. Column B contains descriptions of those items. Columns C-F
contain a random listing of the numbers from column A.

I want to replace the random listings of items in C-F with the
descriptions of the items from column B.

There are 1300 items. Can I do this without running 1300 Find and
Replaces?

I would be happy with four new columns added that have the descriptions
for the random items in C-F in the same order (not exactly a replace).

Thanks!

Al

Find and replace
 

Happy to help...........thanks for the feedback

Vaya con Dios,
Chuck, CABGx3



" wrote:

Great! This saved me hundreds of hours over the next year!

Al

CLR wrote:
In G1 put this and copy down
=VLOOKUP(C1,A:B,2,FALSE)
In H1 put this and copy down
=VLOOKUP(D1,A:B,2,FALSE)
In I1 put this and copy down
=VLOOKUP(E1,A:B,2,FALSE)
In J1 put this and copy down
=VLOOKUP(F1,A:B,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



" wrote:

I have a table with 6 columns, A to F. Column A contains unique item
numbers. Column B contains descriptions of those items. Columns C-F
contain a random listing of the numbers from column A.

I want to replace the random listings of items in C-F with the
descriptions of the items from column B.

There are 1300 items. Can I do this without running 1300 Find and
Replaces?

I would be happy with four new columns added that have the descriptions
for the random items in C-F in the same order (not exactly a replace).

Thanks!

Al