| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH & IF Functions
I am using the follow array formula =MATCH(true,b10:f10+b:15:f15100,0). Is
there a way using the IF function or another function to have the formula not evaluate the values in say column "c" but still count column "d" as the third column in the range? Thank you in advance for your assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with HLOOKUP and MATCH functions | Excel Worksheet Functions | |||
| Multiple Functions IF, AND, COUNTIF, MATCH | Excel Worksheet Functions | |||
| Match and index functions: corrlating data from 2 worksheets | Excel Worksheet Functions | |||
| When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions | |||
| How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions | |||
Threaded Mode
