That's the good (and frustrating) thing about Excel. For any given problem
there is normally more than one solution.

--
Ian
--
"daddylonglegs"
wrote in message
news:daddylonglegs.24rlom_1142516401.7263@excelfor um-nospam.com...

Another way....

=MATCH(AK1,A2:E2,0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522998