Rob see my reply in the other thread

=MATCH(H9,F8:F17,0)/2+(ISEVEN(F8)/2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RobcPettit" wrote in message
oups.com...
Hi, can I modify the formula =MATCH(A33,F7:F15,0)/2 so that it only
give whole number results. Eg not 1.5,2.5,3.5 but 1,2,3.
Regard Robert