SUMPRODUCT formula help
Glad we could help Serge.
Regards
Bob
"Serge" wrote in message
...
I have learned a lot.
Thank so much Bob and to everyone else that had an input in my request.
"Bob Phillips" wrote:
Yes, use
=IF(ISNA(VLOOKUP(I40, INDIRECT(VLOOKUP(D40,
$R$1:$S$9,2)),2,TRUE)),"",VLOOKUP(I40, INDIRECT(VLOOKUP(D40,
$R$1:$S$9,2)),2,TRUE)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
|