Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
According to kbhowtomaster KB275170 (HOW TO: Perform a Two-Dimensional Lookup
in Excel 2000) the following MATCH statement is possible: MATCH(E2&F2,A2:A4&B2:B4,0) Does this only work in Excel 2000? It does not work in Excel 2003. I would like to lookup a value based on 2 criteria from two columns, as follows: Find Amount for Resource 000 for the month of 200807 (July 2008) resource amount month 222 463.12 200801 000 1039.28 200807 000 87.99 200801 222 197.46 200807 444 60.79 200807 444 50 200801 888 -174077 200801 888 1995.59 200803 Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract or report multiple arrays if a cell match a criteria | Excel Discussion (Misc queries) | |||
Looking up data by row and column (Arrays, Lookups, Index, Match?? | Excel Worksheet Functions | |||
MATCH being sent two arrays | Excel Worksheet Functions | |||
Use of offset and match functions with changing arrays, I think??? | Excel Worksheet Functions | |||
Using the sum function in a 3 dimension environment | Excel Discussion (Misc queries) |