View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bryan Kelly Bryan Kelly is offline
external usenet poster
 
Posts: 25
Default Jon Peltier question: use of MATCH

I am trying to use the match command. From the Excel help file I built this
line of code

test_variable = MATCH(39000,B2:B8,1)

I added "test_variable =" to what I copied from the Excell file.
Excel does not like the colon between the B2 and B8 saying it wants a
separator.

The line from Jon's original note was
Name: ET
Refers To: =MATCH("Elapsed Time",Sheet1!$1:$1,0)



Excel doesn't like either one. How do I get this match to work?

--
Bryan Kelly
Time is the medium we use to express out priorities.