nested formula

[Ctech]

=VLOOKUP(TM1!B192,(CONCATENATE("List2B_",TM1!B14)),3,FALSE)

This formula, is to check for a value, in a named range. The Range depends on what the CONCATENATE("List2B_",TMS!B14) generates...


However Im getting an error when doing this.. anyone know why?

[Edward]

Try INDIRECT(CONCATENATE(...))

"Ctech" wrote:

>
> =VLOOKUP(TM1!B192,(CONCATENATE("List2B_",TM1!B14)),3,FALSE)
>
> This formula, is to check for a value, in a named range. The Range
> depends on what the CONCATENATE("List2B_",TMS!B14) generates...
>
>
> However Im getting an error when doing this.. anyone know why?
>
>
> --
> Ctech
>
>
> ------------------------------------------------------------------------
> Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=525716
>
>