need cell to populate info from anther sheep depending on info entered.

I need a VBA that when range C3:C4 cells =XXX then enter the value of the corresponding cell in range b3:b40 in the next open cell in column D on sheet YYYY.