Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I got it working with this...thanks for the replies!
=SUM(INDIRECT("Charges!"&ADDRESS(MATCH($C136,Charg es!$C$1:$C$401), 8)&":"&ADDRESS(MATCH($C148,Charges!$C$1:$C$401)-1,8)))/2000 -Bruce |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup and Trace Return Cell | Excel Discussion (Misc queries) | |||
VLOOKUP to return Cell Address | Excel Worksheet Functions | |||
To return a blank cell rather than 0% in a vlookup. | Excel Worksheet Functions | |||
USING VLOOKUP TO RETURN A CELL ADDRESS | Excel Worksheet Functions | |||
Vlookup return 0 when cell is blank | Excel Worksheet Functions |