I have a spreadsheet with columns A, B, C, and D where column A, B, and C is a PROCV where you search for the e-mail address in other spreadsheets of each vendor and column D is the name of the person responsible, A, B, and C represent each salesperson on my team, so when procv finds the email address on each salesperson's worksheet it returns that address, otherwise it returns unallocated text.
My need, when the address was found in column A by procv in the responsible column which is D to display seller1, when it is found in column B, display in column D seller2, and so on.
Can you help?