ExcelBanter - nested formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - nested formula (https://www.excelbanter.com/excel-programming/356915-nested-formula.html)

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

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

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

--
Ctec

-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=52571

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