Need a formula that incorporates vlookup or similar -

i need formula list of unit #'s in column based upon results of 2 different columns. range approx. 200 rows. example:

a        b             c unit #   inspection    date 100      pass          4/12/14 101      pass          4/20/14 102      fail          4/23/14 103      pass          4/21/14 

the formula @ columns b & c , if said "pass" , date within last week, list unit # (for 200 applicable rows). result in format: 101, 103, etc.

thanks help!

add 2 more columns, weeknum in col d , extract in col e; add below formulas:

d2: =weeknum(c2)

e2: =iferror(index(a:a,small(if(($b$2:$b$200="pass")*(weeknum(today())-$d$2:$d$200<=1)*($d$2:$d$200>0),row($b$2:$b$200)),row()-row($b$1))),"")

the formula in e2 array formula , needs confirmed ctrl+shift+enter. gives unit# of pass items fall previous week or current week.

if want list falling in current week, change $d$2:$d$200<=1 $d$2:$d$200<1.