View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default arguments in MATCH and OFFSET functions

I have the following formula:

=IF(OFFSET(A8,0,MATCH($H$6,B$7:$G$7,0))=OFFSET(A8 ,0,MATCH($H$6,$B$7:$G$7,0)-1),"OK","Check")

I understand everything it does, except for the arguments used in the MATCH
and OFFSET functions. Specifically, I'm referring to the 0 argument in both
functions.

Thanks,

Dave

--
Brevity is the soul of wit.