View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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)