I'm using the formula:
=SUMPRODUCT(--(Honda!A7:Honda!A102=2),--(Honda!D7:Honda!D102="no"))
to display the amount of deals that are pending for a given finance manager
(in this case represented by the 2) . But I would also like to be able to
display the customer name which would be coming from the B column.

So for example, if there was 1 deal pending for manager 2, instead of the
cell displaying 1, it would say "smith" or whatever the customer's name was.
Also, can I display the names in a range of cells if there is more than 1
deal pending at a time.

Thanks in advance for the help!