Yes I want to say:
If value in Column E2 (worksheet 2) matches value in Column E10 (Worksheet 1) then return value in column D10 (Worksheet 1) into cell E4 (Worksheet 2)
OR if value in column D10 (Worksheet 1) is equal to "0" Return "Complete" in cell E4 (worksheet 2).
Hope this isnt too confusing!
Thanks!
Bookmarks