-------- Originele bericht --------
Van: Rogier van Vlissingen <[email protected]>
Aan: [email protected] <[email protected]>
Datum: sat, 10 jan 2009 23:28:41 -0500
> This is what I'm trying to do:
>
> =AVERAGE( HLookup(X14, ConsBillArray, 11) : HLookup(x15, ConsBillArray,
> 11) )
>
> and in this form it returns an error.
>
> What happens is, the HLookups produce a number, not a cell reference, and
> therefore AVERAGE is now looking for a list of numers, separated by
> commas, and I can't use the array specification.
>
Rogier,
I assume that your lookups return both corner coordinates of the array
as a string like "B2" and "C5"
You can than write a formula like:
=AVERAGE(INDIRECT("B2:C5"))
But you have two arguments i.s.o. one. The following step is:
=AVERAGE(INDIRECT(CONCATENATE("B2"; ":"; "C5")))
The last step is to replace the "B2" and the "B3" with your HLookup() I
did not test that, but I'm convinced this works.
Success,
Erik
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
