How can I have excel:
1) search a specific row, e.g R4:R500 and for every occurance of a non-blank
cell
2) bring back what corresponds to that row in col D?

Thanks