View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Optitron[_3_] Optitron[_3_] is offline
external usenet poster
 
Posts: 1
Default Match cells by columns


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