| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match
Welcome, Bob
.. just need to make sure the data is sorted in ascending order .. The above shouldn't be necessary since the MATCH is set to look for an exact match (by virtue of the zero) And you could also improve the robustness of the matching for col D by using TRIM, viz. change: (D$2:D$5050="Actual") to: (TRIM(D$2:D$5050)="Actual") within the expression -- Max Singapore http://savefile.com/projects/236895 Downloads:17,400 Files:358 Subscribers:55 xdemechanik --- "B~O~B" wrote Max and Smartin, Thanks you both for all your help. I was able to get it working just need to make sure the data is sorted in ascending order, but, smartin I think your “=INDEX(C$2:C$5050,MATCH(MAX(IF((A$2:A$5050=A3)*(D $2:D $5050="Actual"),C$2:C$5050)),IF((A$2:A$5050=A3)*(D $2:D$5050="Actual"),C $2:C$5050),0))” will help with that it keeps returning #N/A. When I have some more time I will look into some more, but, thanks you again… |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| need to return next match of table, only finding first match...HEL | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Hybrid Mode
