Sorry for the delay...

Thanks for the example - it really helps explain what you are looking for.

What you are describing is a situation where you have a list with a missing
parameter.
A second list details what the missing parameter should be for any item in
the first list.

The easiest solution is a lookup type function in column B.
[the following is my favorite]

But be aware that this function will fail if the entry in column A does not
exist in column C.

Change A6 to the row where you first put it. (so if you put it in B2, use
$A2)
than fill it down as far as you need it.

=INDEX($D:$D,MATCH($A6,$C:$C,0),1)

You can do this in code. Post back if you need code.

And also let us know how this works for you...

keep on Exceling...

--
steveB

Remove "AYN" from email to respond
"Optitron" wrote in
message ...

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 tools
in column A by themselves with no numbers. Column C&D come from the PDF
matched together. I need column D's number to match with column A's tool
in column B.


--
Optitron
------------------------------------------------------------------------
Optitron's Profile:
http://www.excelforum.com/member.php...o&userid=26729
View this thread: http://www.excelforum.com/showthread...hreadid=466531