On 2002-04-13 16:48, Yogi Anand wrote:
On 2002-04-13 16:35, Chris Davison wrote:
Mornign All,
I'm getting an error on the following :
=VLOOKUP(2,{1,"Chris";2,now()},2,0)
am I right in thinking I'm not allowed to use ANY volatile functions in arrays ?
thanks
Chris
Hi Chris:
As I mentioned in my post above I believe you can not use any FUNCTION, or even a CELL REFERENCE in an array. One can however, like in your instance use the INDIRECT FUNCTION ...
=INDIRECT(VLOOKUP(2,{1,"Chris";2,"E19"},2,0))
where E19 houses =NOW()
and I did get the result as 4/13/02 7:43 PM
Keep up the good work buddy!
Like this thread? Share it with others