Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
It seemed simple:
={SUM(VLOOKUP((F15:F19);DataRLambda;2;FALSE))} should work, but doesn't. F15 is used every time for evaluation in VLOOKUP. I have some experience in excel so I don't think it's any obvious mistake. My conclusion is that using Vlookup in a formula array doesn't work. Can anybody second that? Did anybody find an elagant workaround? (I could create extra calculations in extra columns or even some VBA programming). Thanks, Bart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Vlookup formula using tax yables | Excel Worksheet Functions | |||
Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
vlookup with table_array constructed from mid formula | Excel Worksheet Functions |