| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New 2007 Sumifs formula - Is there a new 2 criteria vlookup?
Is there a new multiple criteria vlookup in 2007 just like there is the new
sumifs formula eg does not need to be an array formula, can reference columns instead of cell ranges etc. I am currently using {=INDEX('Sheet!$O$2:$O$35000,MATCH(1,('Sheet'!$Q$2 :$Q$35000=D2)*('Sheet'!$M$2:$M$35000=F2),0))} |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIFS formula using dates and text as criteria | Excel Discussion (Misc queries) | |||
| New 2007 Sumifs formula - is there a new multiple criteria vlookup | Excel Worksheet Functions | |||
| Sumifs formula in Excel 2007 | Excel Discussion (Misc queries) | |||
| sumifs formula in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 - SUMIFS formula use between tabs | Excel Discussion (Misc queries) | |||
Threaded Mode
