=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