excel 2007 - How do I match 2 columns data and when a match is found copy a 3rd column of data to a 4th blank column -

example:

column        column b       column c     column d 90516-9240       107461                     107461 90516-9574       124174                     107461 90516-9665       143064                     124174 90516-9268       148725                     124174 90516-9267       161747                     128986 90516-9586       171964                     133339 

where if number in column b matches number in column d number column fill column c

so this:

column        column b       column c     column d 90516-9240       107461        90516-9240   107461 90516-9574       124174        90516-9240   107461 90516-9665       143064        90516-9574   124174 90516-9268       148725        90516-9574   124174 90516-9267       161747                     128986 90516-9586       171964                     133339 

what simplest formula can use this.

this can done lookup using index/match. assuming row 1 has labels, start in c2 with

=index(a:a,match(d2,b:b,0)) 

if swap columns , b, can use vlookup():

=vlookup(d2,$a$1:$b$1000,2,false) 

copy down.