View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wahine Wahine is offline
external usenet poster
 
Posts: 10
Default Function Help

Thank you.

"MattShoreson" wrote:


or you could use choose.

=CHOOSE(MATCH("x",A2:G2,FALSE),A1,B1,C1,D1,E1,F1,G 1)*H2


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=563626