| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help... almost done with this project
OK That is COOL. can you explain how it works. I might want to duplicate it
in another application. Thanks again for all the help! "Max" wrote: Steve, This revision should do it. In M14 (normal ENTER will do): =IF(OR(E10="",B22="",E16=""),"",INDEX(INDIRECT("'" &E10&"-"&B22&"'!E61:H61"),,MATCH(E16,{"A";"B";"C";"D"},0) )) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "S Willingham" wrote: Thanks Max E61 to H61 contain the info needed. That is, they contain the total of the quote for the color group A-D I entered the formula and it returned a #N/A |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
| Help with a project | Excel Discussion (Misc queries) | |||
| Lock Project | Excel Discussion (Misc queries) | |||
| Need a project. | New Users to Excel | |||
| I pay $ for this project | Charts and Charting in Excel | |||
Hybrid Mode
