A = screwdriver, hammer
C = hammer, screwdriver
D = 1234, 4321
B should = 4321, 1234

This is how I have to copy it from a PDF file. First I have the tool
in column A by themselves with no numbers. Column C&D come from the PD
matched together. I need column D's number to match with column A's too
in column B

--
Optitro
-----------------------------------------------------------------------
Optitron's Profile: http://www.excelforum.com/member.php...fo&userid=2672
View this thread: http://www.excelforum.com/showthread.php?threadid=46653