Look up a field from one sheet and paste it to other conditionally

[prateekvitian]

I have one date range condition and one name condition

For instance

name in one sheet matches the other
and then date should lie between start and end date given on different sheet
then for that row copy a column to a column in this sheet

Plz reply ....its urgent

[samba_ravi]

attach sample excel file