Not enough information supplied to help you.

Post back with simplified examples.

A = ???, ???, ???
C = ???, ???, ???
D = ???, ???, ???
B should = ???, ???, ???

The above says that we have 3 different examples and 3 different results.

--
steveB

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

I need COLUMN B to show what is in COLUMN D depending on what is in
COLUMN A with a formula:

(COLUMN A) (COLUMN B) (COLUMN C) (COLUMN
D)
A(BOX 1) C(HAMMER)
D(1234)
A(SCREWDRIVER) B(?) C(SCREWDRIVER)
D(4321)
A(HAMMER) B(?)

A(BOX 2)
A(HAMMER) B(?)
A(SCREWDRIVER) B(?)


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