Hello all i am stumped with this but this formula always returns the last * character in a list
{=IF(A2=""," ",INDEX(F2:F18,MATCH(TRUE,EXACT("*",E2:E18)),1))}
so regardless of the range i choose i always get the bottom result, in this example:
<tbody>
Bodyshop/Adhesive & Sealant always...