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


--
ovid962
------------------------------------------------------------------------
ovid962's Profile: http://www.excelforum.com/member.php...o&userid=35452
View this thread: http://www.excelforum.com/showthread...hreadid=552302

Find and replace
 

Assuming that you have 100 different items (number in A and description
in B) A1:B100

use a vlookup in G1

=VLOOKUP(C1,$A$1:$B$100,2)

and just drag and fill to the same area size as C1:F??


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552302

Find and replace
 

Then you can just copy the G1:J? range, and paste special (Values) over
C:F


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552302

Find and replace
 

Answered in .misc newsgroup...........

Vaya con Dios,
Chuck, CABGx3



"ovid962" 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


--
ovid962
------------------------------------------------------------------------
ovid962's Profile: http://www.excelforum.com/member.php...o&userid=35452
View this thread: http://www.excelforum.com/showthread...hreadid=552302

Find and replace
 

=VLOOKUP(C1,$A$1:$B$1300,2,FALSE)

See if this formula helps. you could put this in G1 and then copy it down
and across.
It should look at what is in C1 (which should be one of your random number
codes), then it will look at all of A1 to B1300 and find the number code
match and display the 2nd column over (which is the description). Test it
out and see if it works for you.

"ovid962" 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


--
ovid962
------------------------------------------------------------------------
ovid962's Profile: http://www.excelforum.com/member.php...o&userid=35452
View this thread: http://www.excelforum.com/showthread...hreadid=552302