| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search column, hyperlink, offset, substitute, match (omg) | Excel Discussion (Misc queries) | |||
| MATCH and OFFSET | Excel Worksheet Functions | |||
| Use of offset and match functions with changing arrays, I think??? | Excel Worksheet Functions | |||
| Formula Help With MATCH & OFFSET | Excel Worksheet Functions | |||
| Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
Threaded Mode
