Excel Function VLOOKUP - ARRAY Function Error

[elstuart]

Hi,

I'm having trouble looking up a table of "Names". The table deifene
below is called ROL_IS and list hundred of other defined tables.


Error where:
=VLOOKUP(A33,VLOOKUP(CUR_MON,ROL_IS,3,FALSE),2,FALSE)

but no errors where
=VLOOKUP(A33,ACT_IS,2,FALSE)
or
=VLOOKUP(CUR_MON,ROL_IS,3,FALSE) ANS: ACT_IS

The array function in VLOOKUP appears not to converting formula to
NAME.

If anyone knows or needs further details if would be appreciated.

Thanks

Elizabet

 

[Peo Sjoblom]

If I understand you correctly

=VLOOKUP(A33,INDIRECT(VLOOKUP(CUR_MON,ROL_IS,3,0)),2,0)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[elstuart]

Thanks Peo, using INDIRECT worked!

Time appreciated

Elizabet