Forum

Mynda, Thank you ever so much. I didn't understand the range thing on the list--it wasn't sinking in, but I do now. I also didn't know Duplicates ...

Should there be $ on the 1:1416 to lock the rows? =INDEX(list,IF(SUMPRODUCT(ISNUMBER(SEARCH(list,B2)))=0,NA(),SUMPRODUCT(ISNUMBER(SEARCH(list,B2)))*R...

I've attached my file. Perhaps you could give it a look and give some counselling and direction. I really want to understand this without having to ...