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.
|